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] |
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] |
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] |
All times are GMT +1. The time now is 05:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com