Report Totals

[Crazy Ganet]

Hi, I have what is probably a really simple problem but I'm going round in circles!

I have a report based on a cross tab query. I'm trying to total 2 columns of the cross tab, using the unbound text box with the control source: =SUM([PAC]+[Complete]) this is returning a nonsense value and I have no idea why!

Any help/thoughts on this would be much appreciated!

 

[Ziggy]

what section of the report desing did you place the control? You can't calculate in the page footer if that is where you put it

 

[Gates Is Antichrist]

I suggest running the report wizard against that query (be sure to click on "Summary options" in the process), creating a new scratch report, and comparing what you have to that. You might even copy/paste from the scratch table to yours.

 

[Crazy Ganet]

Great that works, sometime the simplest things are the hardest!


Thanks heaps!

 

[Gates Is Antichrist]

Don't feel bad. For the longest time, on earlier Access versions, I wondered if it was impossible for me to insert a total on a report. The only way that ever worked for me was to use the wizard!