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*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Multiple Parameters 7
Best solution to merge multiple Outlook contacts easily 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Criteria Parameter in query for two fields: help 1
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Parameters 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1

Back
Top