Record totals from multiple queries

[MickM]

Hi All,

Just need a bit of direction here. I have multiple queries (15 or so) that I want to be able to get the total number of records for each query at any point of time. The totals are appended to another table so I can build a graph (trendline) from the data.

I know I can use Dcount and create an append query for each, but is there a simpler way?

Cheers
Michael

 

[Ron_dK]

I would say, base your graphics ( trend lines and such ) on the queries directly. It's not common practice to store calculated data in a table.

 

[MickM]

Thanks Ron,

How would you create a trend line if the query totals are changing weekly without storing that data?

Michael

 

[Ron_dK]

Could this be of any help :

http://support.microsoft.com/kb/210024

 

[DCrake]

Personally I would use a Union query to get the individual totals and base the trend line on the resulting query.

If you select the total from the query and a description regarding its source then you will be able to use them as data labels.

David