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.
