I have 4 queries needed to power one report. I've tried combining the queries into one so I can run the report off that. However, there is too much data and I get all sorts of errors. My only solution was to toss that data into a table thereby eliminating all the calculations and expressions and cleaning up the data. Is there a more elegant solution to this issue?

Sometimes that is the best way. I just usually use a work table that I leave there all the time and delete all the rows before I start, and use append instead of maketable.

I find if you don't know what you're doing (which the people this db is intended for don't) then update queries can get a little messy. Oh well, it was a shot in the dark. Thank you for the quick reply.

No, the users don't know what is going on, I usually use a MACRO to run the queries and the report, they just click a button, or something.