Select Records

[shapper]

Hello,

I have an Access Database Table with 2 fields:
1. ID
2. Name

I want to Select all the records which [Name] is contained in a
parameter which I pass in the following format:

"Name1,Name2,Name3,Name4"

Thanks,
Miguel

 

[Marshall Barton]

I have an Access Database Table with 2 fields:
1. ID
2. Name

I want to Select all the records which [Name] is contained in a
parameter which I pass in the following format:

"Name1,Name2,Name3,Name4"

Use a calculated field in the query:

InStr("," & parameter & ",", "," & [Name] & ",")

and set its criteria to: