Criteria in a query

[ravikode]

Hi,

I wanted a selection Criteria in a query. So I typed "[Enter QuaterNumber: ]" in the query and it works fine for that. What should I do if I want to

* Get all the records from the same query.( I entered "*" but did not work.)

* Enter multiple parameters.

Thanks
Ravi

 

[Norie]

Ravi

For the first quesion try this

Like "*" & [Enter QuaterNumber: ] & "*"

Can you explain the 2nd question further?

 

[ravikode]

Thankyou very much for your response.

Like "*" & [Enter QuaterNumber: ] & "*" works fine for the first question.

My second question was.. Enter multiple parameters.
Say I want to enter two QuaterNumbers. Example: 2,3
how can i get that.

 

[Norie]

Are quarter numbers actually numbers in your table?

If they are you can't use the Like operator and you don't need single quotes.