T
THPCT
This is driving me mad can someone help please:
How do i add the values of a column in a query in Access
How do i add the values of a column in a query in Access
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry Whittle
You do a totals query and use the Sum function.
K
kc-mass
Let's say you have two fields, Price and Tax both defined as currency.
Place those in columns 1 and 2 of the query design panel. In the 3rd column
put in an Expression rather than a field name.
TotalPrice: Price + Tax
If the Price is $10.00 and the tax is $3.20, the expression Total will yeild
$13.20.
SQL will look like :
SELECT tblNetprice.Price, tblNetprice.Tax, [Price]+[Tax] AS TotalPrice
FROM tblNetprice;
Regards
Kevin
Place those in columns 1 and 2 of the query design panel. In the 3rd column
put in an Expression rather than a field name.
TotalPrice: Price + Tax
If the Price is $10.00 and the tax is $3.20, the expression Total will yeild
$13.20.
SQL will look like :
SELECT tblNetprice.Price, tblNetprice.Tax, [Price]+[Tax] AS TotalPrice
FROM tblNetprice;
Regards
Kevin
P
pietlinden
This is driving me mad can someone help please:
How do i add the values of a column in a query in Access
Or are you referring to a totals query?
SELECT SUM([MyNumericField]) As Total
FROM MyTable;