Search results

tried that. still cannot view in design mode

Yes, thanks. Hopefully you can see this attachment "picture 1.jpg" which is a screenshot that shows it is just a regular append query. It does not even allow me to change it to a select query...thanks again! In case you cannot see the attached, here is the code: INSERT INTO DETAIL (...

Frustrated though because these are not pass-through or Union queries, just regular select queries.

Thank you, sir. I appreciate your prompt replies and assistance in this matter.

Thanks for your reply Bob but I hope you are wrong :-) There is nothing special about this query. I just think the creator may have saved it this way for some reason. Thanks again.:rolleyes:

Hello, I inherited an Access 2007 DB that was created by someone who is no longer here. A particular query comes up in SQL VIEW when I go to design mode and it is not letting me view it in DESIGN VIEW. Any ideas why that would be and how to get around that? Thanks!