Multiple parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you explainto me how I can have multiple Like p* in a select query. I
know I can do two rows for it but need more than two. Thanks
 
Akrt48,

In the query design grid, you can enter criteria in multiple rows. One
row is labelled 'Criteria', and the next row is labelled 'or', but you
can continue to enter further "or" criteria in the rows of the grid
below that.

Alternatively, you can enter the criteria in one row, using syntax like
this...
Like "p*" Or Like "x*" Or Like "z*"
 
Back
Top