Query and Total Sum

[Leonidas]

I have a table with columns Date and Price. With
"SELECT table.date, table.price
FROM table
WHERE (((table.date)>#4/3/2007# And (table.date)<#4/30/2007#))
ORDER BY table.date;

I extract the data that I need. But I also need the total sum of the prices
I extracted.

Thanks

 

[Jeff Boyce]

Leonidas

Your query includes date and price. If you could have more than one price
per date, do you want the sum, per date, or the sum across dates?

If you want the sum across dates, something like:
SELECT Sum(table.price) as TotalPrice
FROM table
WHERE ...
would give you a sum.

Regards

Jeff Boyce
Microsoft Office/Access MVP