G
Guest
I have beat my head against a wall for two weeks on this problem. I have 8
queries that I need to pull onto a form. The problem: 800,000 items in those
8 queries. I have tried building a "super" query with all 8 queries pulled
into one but that is too slow and takes to long to run (like all weekend to
get results.) I then tried with subforms and I got it built that way but I
can't format the form like I want it because each subform takes up a lot of
room and I can't align the data in the way it has to be. I then tried
tab-pages and tab-pages with subforms and I can't get the form to work
properly. It won't coordinate each tab, in other words I'm on New York on one
tab and I flip over to the next tab and it's on Omaha. Is there any solution?
Thanks so much!!!!!
queries that I need to pull onto a form. The problem: 800,000 items in those
8 queries. I have tried building a "super" query with all 8 queries pulled
into one but that is too slow and takes to long to run (like all weekend to
get results.) I then tried with subforms and I got it built that way but I
can't format the form like I want it because each subform takes up a lot of
room and I can't align the data in the way it has to be. I then tried
tab-pages and tab-pages with subforms and I can't get the form to work
properly. It won't coordinate each tab, in other words I'm on New York on one
tab and I flip over to the next tab and it's on Omaha. Is there any solution?
Thanks so much!!!!!