Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |