an odd report that just has calculations on it.

[Junior1544]

I need to create a report that will just show some totals...

i know how to show the data in a query, last time i just made the query for each number she needed and told my boss the total records... how can i automate this into a report?? all i need on it is the 6 totals... she's going to be running this pretty often... being that the data is housed in different tables, i would like there to be a prompt for the time frame the report is suposed to represent... i have no idea where to start...

i've looked at crosstab queries, but that just confuses me... i would be greatfull for any and all help... thanks

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[GoDawgs]

Kinda confused by your question, but the best I can come up with is this: It seems like you know how to make a report that shows all the information, but you just want to show the totals. If this is the case then you can solve this easily...just set the visible attribute of the "detail" section in the report equal to false...this way only the sums will show up. Hope that helps.

Kevin

 

[Junior1544]

that is exacly what i want to do, and i thought about that already... but i need to do it multiple times for different tables... was just hoping i could find an easier way then doing this multiple times for each total i need...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.