Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TO
 
Posts: n/a
Default How do I enable the criteria pane in MSQuery (Excel 2003)?

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.

  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

If the SQL code is uncomplicated (from MS Query's prespective), you should be
able to see the Criteria section by selecting ViewCriteria.

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?
--
Regards,
Ron

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"