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