Urgent report help required

[callaway]

I have a report based on a cross tab query which lists profit made on sales orders by month from deposits and final balances.

My detail section has two sets of data fields called dep_jan, dep_feb, etc, and bal_jan, bal_feb, etc. These are bound to the underlying query and include some 'iif' logic in their control source.
The detail section is grouped by order number.
The output from the detail section is fine and shows correct data as shown below:

order dep or bal? jan feb mar apr may ....
1234 dep 100

bal 300

etc

However when I try to do a grand total at the end for each month I get '#Error' when I try to set the control source to =sum(dep_jan), etc.
Can I total on a field that the report has generated itself and that is not bound to the query?

Hope this makes sense? Any suggestions?

regards.

 

[golgo1]

This may not be the best way to get your sum, kind of a different approach. You could just delare variable global to the report, then keep adding the value from the detail section to the variable. at the report or detail footer, place the variable value to the textbox (or whatever) that the sum should be displayed in. Like I said, different type of solution, but it may give you the results you want.