Can't calculate Grand Total of several other expressions

[Karen]

Setup: *Query 1 selects records within date range
*Query 2 includes all fields from 1 but is a one line result because it sums
the fields and creates new fields doing a calclation using the sums (i.e.
food provided (sum), food value (sum * amt))
*query 3 includes everything from 2(from 1) but need to get grand total of
all value fields from query 2 so this result is essentially one line of data
showing individual values and want it to show a grand total of those values

I have not been able to get the grand total calculation to work...I do not
get an error and it shows as a field in the result but no value is there...SO
I got rid of query 3 because it was only used to calculate the grand total
and tried to calculate the grand total in the report but this causes another
problem..

when the report runs it asks me to input a parameter for query 2 but I do
not have any criteria in query 2, only calculations. I had put the sum
expression in an unbound text box and tried it in the report footer and page
footer.

I know it's probably something very simple that I'm missing, maybe even
syntax, but I'm getting frustrated. Please help.

Thank You.

 

[Duane Hookom]

Consider providing us with the SQL view of your queries.