How do I enable the criteria pane in MSQuery (Excel 2003)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A Microsoft Query previously set-up in Excel 2000 does not show the Criteria
Pane when opening it in Excel 2003. Also, the criteria selections on the
toolbar have been greyed out and are, therefore, unchangeable. Is there a
setting that needs to be changed? The SQL code is still visible and
changeable, but my users are more comfortable seeing the criteria in
easy-to-understand column/row format. Any suggestions are welcome.
 
If the SQL code is uncomplicated (from MS Query's prespective), you should be
able to see the Criteria section by selecting View>Criteria.

Otherwise, it probably means that the SQL has been edited such that MS Query
can't display it in the query editor windows.

Does that help?
 
You must log in or register to reply here.

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

msquery in Excel 2007 1
Frozen panes in Excel should stay put when using autofilter. 8
SQL ODBC MSQuery in EXCEL 1
How can I sum numbers that have a gray color-fill in cell? 1
MSQuery error:Cross Join option is not enabled. 1
How do I freeze/ unfreeze a window pane in Excel 2007? 2
Find Access Database Used by MSQuery in Excel 2003 1
How To Use Range Names In Data Validation Criteria (Not For Lists) 1

Back
Top