Sep 27 2008, 01:19 PM
I'm getting a syntax error on a query that took me all day to create. When I try to get into design mode I get an error message box with a cancel button and a help button. It won't allow me to do anything except press the cancel button which aborts the query. So, if I can't open the query I can't fix it.
Is there a way to get around this issue?
Sep 27 2008, 01:27 PM
try running the query from the SQL view ... if it is a syntax issue, Access will tell you where the problem is. If it is a logic issue, perhaps you need to nest queries instead of doing so much with one.
what is the SQL?
Sep 27 2008, 02:34 PM
Can't. I only get the "design" view option
Sep 30 2008, 01:40 AM
what version of Access are you using?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here