How do i add the values of a column in a query in Access

  • Thread starter Thread starter THPCT
  • Start date Start date
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
 
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
 
This is driving me mad can someone help please:

How do i add the values of a column in a query in Access
Click to expand...

Or are you referring to a totals query?

SELECT SUM([MyNumericField]) As Total
FROM MyTable;
 
Back
Top