Cumulative Totals 1

[bpifer23]

I have some information that was calculated in a query and that is passed into a report. That is simple enough. But what I need is to allow these totals from the query to be stored (I'm assuming in a table)for use in later reports. Would using an Append Query be the best choice for this or is there an easier more efficient way?

Thanks a head of time,
Brian

 

[Aqif]

Hi,

I think Append query or update query (if u want totals to be over written) will be the bext choice. I am using one database where I do the same as the queries which gives totals r really complex and takes a long time. So I generate totals in temp table so that user can run reports quickly.



Cheers!
ÙÇãá

It's important to learn the rules so that you know how to break them.