jayphilips
IS-IT--Management
Hi,
I have 30 different queries, they each have a column called EER (this is the most important), then they have 2 other columns depending what query #. I checked the relationships window and made sure that the EER is joined from Query1 to all the other queries.
What I am trying to do is create a way to run all 30 queries in the background that will then display a report.
I tried doing this by using a macro but that didn't go very well because all 30 queries displayed seperatly and none of them displayed on the report.
Is there a way to have the queries run in the back and not actually open all the way?
Can someone please help me? Jay
Get The Exposure Your Web Site Deserves
I have 30 different queries, they each have a column called EER (this is the most important), then they have 2 other columns depending what query #. I checked the relationships window and made sure that the EER is joined from Query1 to all the other queries.
What I am trying to do is create a way to run all 30 queries in the background that will then display a report.
I tried doing this by using a macro but that didn't go very well because all 30 queries displayed seperatly and none of them displayed on the report.
Is there a way to have the queries run in the back and not actually open all the way?
Can someone please help me? Jay
Get The Exposure Your Web Site Deserves