Cannot view query in SQL View

Question

All -

I have Win XP with Access 2003.  I have query but I am having trouble opening it to view.  Everytime I tried to click on Design, Access gives me a "Join expression not supported" message.  But there's no way to view it in SQL.  What can I do to get it open in SQL View?

Thank you in advance,

Ben

---

NoSpam007

Answer 1

Yeah.  You can get the actual SQL statement in the VBA window.  In the immediate window enter

? CurrentDb().QueryDefs("Name of the query").SQL

Once that prints in the immediate window, you can copy it and then open the query in design view and switch to SQL View.  Once there you can either fix the join expression and save the query in SQL view or paste the SQL string and save in SQL view.  NEVER go back to design view on this query.

---

John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County

Answer 2

John,

Thank you, using your suggestion I was able to get to the SQL statement.

Thanks for your help.

Ben

---

NoSpam007