Microsoft Query

G

Guest

I'm using Excel to query an oracle database. When I go to Microsoft Query to
edit my query, I can't view my criteria or tables. I click on the view menu
and am unable to select view "criteria" or "tables". Thus, all that shows up
in the screen is the data in my query. This has happend to me before. Can
anybody help me?
 
G

Guest

I was able to answer my own question. It seems when query is complicated
enough, you are unable to view the criteria, since you are now using SQL to
query the data. It seems that if you click on the SQL button and scroll
down, delete the part of the query that is "too complicated", you wil then be
able to view the criteria screens as you typically view them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query - unable to edit query 9
Pass date parameter into MS Query 2
Can't create a report from my query in Access 1
Too few parameters 2
Syntax Error In Date 2
Can you change or alter source data using microsoft query? 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Top