Sum of Fields Across Records

[The Professor]

Hi,


I have a simple query, which works well enough as far as it goes, but I need it to show me the combined total of the currency field.
For example, the Query will show me a list of all customers who have not yet paid, and the outstanding amount each customer owes, this amount is stored in the currency field. Lets asssume the query shows there are 15 customers, each of which have an outstanding debt. The individual amounts are listed in each record, but I also need the Query to show Grand Total for all 15 records. Is there a way of getting the Query to do this?

Here's hoping,
Prof.

[pbaldy]

Typically you would do this in a report or form, not in a query. It can be done, but it involves using a union query to join the existing query with a totals query.

[The Professor]

Ok, thanks for that. I might just leave the idea on the back burner for now, come back to it later if I have time.

I had hoped it might have been more straightforward than that but nevermind (wouldn't it have been nice though, if the Query, in datasheet view, had a final row at the bottom, in which the total could be displayed).