Having a problem with a design of a Query!!!!!

[jasonz]

Here is the situation: There is a
Status_of_Payment table that includes a field called
check_amount; which spits out currency values. Well I
made a query with a couple fields in it and one of them was like this "Monthlybill: Sum(([Check_Amount]*0.07))
Well this is a really nice query because I have another field that has this as the criteria for the dates: "Between [Type the beginning date:] And [Type the ending date:]"; which sets the range forwhat I need to run.
Well here is the problem: I need to figure out how to add up the totals from the "Monthlybill" column on the bottom of the same query or make a new query that gives me the capability of adding up the values and still using the date range run that I used in the first one. Well Please help me and if you could tell me the exact expression to use when I use the expression builder or type it in. I
am a newbe so please be detailed in explanations. Thank
you for your help.

 

[chubby]

Create a report using the one query you already have. Using the Sorting and Grouping function,(in design view in your report) select Group Footer. Use the expression =SUM([field Name])which adds up your totals for a specific range. Note: Use the Group footer to summarize the detail records for that group.

I hope that helps
Chubby...

 

[jasonz]

Hey Chubby,JasonZ here. I tried what you said, but unfortunately I got an error message that states "Cannot have aggregate function in ORDER BY clause (Sum([Check_Amount])). Well anyway, if you could please help me with this problem. I would like to do totals for this field and another field on the same report. I know how to add the other field, but I keep getting this error message. Thanks for the time and help.