Sum in the query

maquino

New member
Local time
Today, 23:54
Joined
Mar 8, 2002
Messages
8
How can I put a column in my query showing the sum of another column, for example I have a column with the prices of a product and want to know the total price of these products.
Thanks in Advance
 
You cannot have both summary and detail rows in the same query unless you union a detail and a totals query and there are problems with this. So, unless you have some special circumstance that you'd care to share with us, do what Rich suggested.
 

Users who are viewing this thread

Back
Top Bottom