Sum of all records in query?

[RichGags]

Ive been trying to get this and my brain is just frozen.

I have a query which gives me values of my table:

Name | DateofEvent | Expr1
Joe 3/15/2003 $1000
Rich 5/15/2003 $2000


How do I get this query to give me the total of all records?
ie.

Count = 2 $3000


Expr1 = Nz([MUSIC])+Nz([PROPS])

Ive been trying to get it to SUM(Expr1), but I must be doing something wrong.

Thanks!

 

[dcx693]

You cannot have record detail and summary detail on the same query. Save your first query and use it to feed into a totals query. You should be able to sum the Expr1 field there.

 

[RichGags]

How would I set up my totals query? When I create a totals query, based on the first one, I make one of my columns

=SUM([Expr1]) but its only totaling the record's $$ and giving me the same value of Expr1. Its not giving me a total even on the report when I reference it in the field.

Thanks.