Jump to content

Query is too complex

adman29
 Share
Posted

Hey everyone. I need a MS Access Guru. I've got an insanely long SQL statement, and whenever I run it, it spits out that the Query is too complex. Is there a work around to this? Can I use more memory or other resources to run the query?

Thanks in advance. If it'd help, here's the SQL Statement (Sorry, it's kinda long). I put it into a .txt file to not take up so much space on the screen.

SQL Troubleshoot.txt

Link to comment
https://linustechtips.com/topic/870404-query-is-too-complex/
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Troubleshooting

×