Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria using "Or" and parameter query
Using MS Query, how do you keep an "Or" query and a parameter query on one
line so that you only need to type in the parameter once. For eg. Criteria: Day Date Value: 'Monday' or ' Wednesday' or 'Friday' Between [Start Date] and [End Date] After you save this query, MS query automatically formats the query on several lines. For eg. Criteria: Day Date Value: Monday Between [Start Date] and [End Date] or: Wednesday Between [Start Date] and [End Date] or: Friday Between [Start Date] and [End Date] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
Parameter Query in MS Query | Excel Discussion (Misc queries) | |||
parameter query - multiple options | Excel Discussion (Misc queries) | |||
How do i enable the Query Parameter menu option on the External D. | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |