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

This is driving me mad can someone help please:

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

You do a totals query and use the Sum function.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"THPCT" wrote:

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
"THPCT" wrote in message
...
This is driving me mad can someone help please:

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

On Dec 14, 10:27*am, THPCT wrote:
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;