Adding fields from different reports

[adrianvasile]

I have a quick dilema and I was hoping maybe someone could provide insight. Here is my setup:
I have 5 reports - Monday through Friday that will summarize the number of accounts that a Salesman will visit during the day. Then, I have a command button on a form that will run a Macro that will print all reports at the same time - called Print Entire Week. I would like to have on the last report, Friday a count of all records from all reports together.
Each report gets a total by using the RecordCount feature; is it possible to create a formula to add all recordCounts from all reporst?
Thank you

 

[adrianvasile]

I am not good with SQL but I don't think that any of the codes above has anything to do with a calculated field.
Maybe I am wrong.

 

[Remou]

To count the total accounts for a salesman, you group by salesman and count on any key field. I thought you were using calculated to mean one of the standard sql statistical methods.

Does your database contain any particularly sensitive information? If not, find one of the free file upload websites and upload your database so I can download it.

http://lessthandot.com

 

[adrianvasile]

It makes sense - I will try it tommorow first thing.
I wish I can upload it somewhere but it is connected to an AS400 server and it will probably not work outside since it cannot find the server (unless you know a way to do it) - beside it is a mess. I have so many reports and querry that will probably scare away everyone.