How many is too many

[eileen1309]

I have a series of about 40 queries that are either make tables, updates, and appends. If I turned these into SQL strings how many would be too many to run the same function in code?

Thanks
Eileen

 

[hkaing79]

I don't think there is a limit. It just takes a matter of time processing all those queries.

I consolidated all my queries in one report. If I had stuck with building queries, I'd say I would've had to maintain well over 50. It takes about 5 minutes to complete. The advantage is I don't have to sit there and wait for one make table query to finish. I just let the function execute them in order.

 

[eileen1309]

Thanks, I wasn't too sure