How to give parameter query

S

subbu

Hi,
I have requirement to to fetch soem records based on the
some group code which may be SPSREL OR SPSSVM OR
SPSVMN.How to give in the criteria.

Any help in this regard is highly aprreciated

subbu
 
J

JohnFol

You would use the IN clause for the criteria

In ("SPSREL", "SPSSVM", "SPSVMN")

or exactly what you have written

"SPSREL" OR "SPSSVM" OR "SPSVMN"
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to implement two shifts per day with multiple teams 0
Changing recordsource.. query in comboboxes 0
How to give specify dates as criteria in Select query 4
Parameter Value in Crosstab Query 4
Multiple Parameter Crosstab query filter by form 1
How to give group by in the select query 2
query to show where no data in a stated column 0

Top