display sum of products in order (Access)

[matthewb3660]

Hi

I am working on an access database and I need to construct a query to get the total of an order. There is a products table with products and prices and an orders table for orders placed by customers with several fields for each product ordered and the quantity.

Can anyone offer assistance as to how I might do this?

[Hack]

Welcome to DevX :WAVE:

Without knowing the specific table layout, I can only be general.

Basically you would want to use the aggregate SQL SUM function. Something likeSELECT SUM(orders) FROM tablename WHERE blah = blah As OrderTotal

[AngelSoft]

as mentioned by hack i cannot tell u the exact answer what u want
try this out

select sum(quantity) from ordertable group by product

[Hack]

Here is a list of aggregate sql functions (http://databases.about.com/od/sql/l/aaaggregate1.htm) that will doubtless come in handy from time to time.