View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default 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]