Help Me: Total on report from query results

[daclown81]

I created a query to get results from 2 tables. One of the results I got was a numerical amount figure. Now in my report I can get all of the amounts from the query to show up in the details.

How do add all those amounts and get a grand total in the report. Every time I try using SUM(Amount) it only gives me the amount from the last amount figure shown in the details instead of adding them all together.

Thanks

 

[David R]

It sounds like you're putting your Sum() statement in the details section. Place it in the report footer instead.

HTH,
David R

 

[daclown81]

No, I've tried putting it in the footer, but I keep getting an error, or it just gives the last number from the query

 

[Rich]

What's Amount? It should be Sum([Amount])

 

[daclown81]

No it doesn't work........

It's like if you make a query and you have a coulumn with several numbers.....I want to total those numbers in that column and have them show up on my report.

Now I've found that I can make a query of that query and use the Sum and that gives me the total of the column, but I'd rather not have to do that with every report I make

 

[Rich]

Base the report on the query remove the page header and footer and set the detail section to 0.Set the report footer to 0. In the report header put =Sum([YourField])

 

[Jerry Stoner]

Heres a way to cheat. Might just work. Use the report wizard to create a report with the same query as the source when it prompts you which fields you want to summarize select your amount field. Complete the wizzard and it should have the value you want in the report footer.Or you could just use the report the wizzard generates and format it as you need. But... before you do all this try putting =Sum([Amount]) in the detail section.
Sorry Rich didn't see your reply before I started typing.

[This message has been edited by Jerry Stoner (edited 02-06-2002).]

[This message has been edited by Jerry Stoner (edited 02-06-2002).]

 

[daclown81]

It worked!!! Thanks a million guys