Using comma delimited option in one parameter of query
I have an address database with listed customers. It is used for creating mailing labels. In my table I have a column labeled ZipCodes. I have a parameter query to search the zip codes by the user suggested zipcode which in turn sends the data to a report set up in a mailing label format. I am using Microsoft Access 2003. I want to be able to use a comma delimited parameter so the user can enter 30121, 30518, 30067 etc. into this one parameter. My current SQL looks like this:
SELECT [Company Data].CompanyName, [Company Data].Address, [Company Data].City, [Company Data].State, [Company Data].ZipCode
FROM [Company Data]
WHERE ((([Company Data].ZipCode)=[Enter the ZipCode(s):]));
Can someone please show me how my script should look in order to get this to work? I have been looking at past threads for three days now, and can't find an example.
Thanks very much,
matulat
I have an address database with listed customers. It is used for creating mailing labels. In my table I have a column labeled ZipCodes. I have a parameter query to search the zip codes by the user suggested zipcode which in turn sends the data to a report set up in a mailing label format. I am using Microsoft Access 2003. I want to be able to use a comma delimited parameter so the user can enter 30121, 30518, 30067 etc. into this one parameter. My current SQL looks like this:
SELECT [Company Data].CompanyName, [Company Data].Address, [Company Data].City, [Company Data].State, [Company Data].ZipCode
FROM [Company Data]
WHERE ((([Company Data].ZipCode)=[Enter the ZipCode(s):]));
Can someone please show me how my script should look in order to get this to work? I have been looking at past threads for three days now, and can't find an example.
Thanks very much,
matulat
Last edited: