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] |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria using "Or" and parameter query
I'm finding it difficult to understand your question but I suspect you can
add the criteria field to the grid twice, putting the day filter on one that you also may not want to show and the parameter query on the other If this doesn't work for you then try re-phrasing the question. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Troy Man" <Troy wrote in message ... 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] |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria using "Or" and parameter query
Nick,
I have tried to put the criteria in the grid twice. However when you select "or" the field selection goes down the page, which means that I now need to enter a parameter (date range) for each field I need to query. Access lets your "or" query go across the page. Any ideas? "Nick Hodge" wrote: I'm finding it difficult to understand your question but I suspect you can add the criteria field to the grid twice, putting the day filter on one that you also may not want to show and the parameter query on the other If this doesn't work for you then try re-phrasing the question. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Troy Man" <Troy wrote in message ... 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] |
Reply |
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) |