IN operator with multiple values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I pass multiple values using the IN operator on a numeric field.
Example, the table is "Customer" and I want the user to be able to type in
"N" number of customer numbers to show only those customers. I tried using IN
([enter cust. number]) in the Criteria field but I can only type in one
customer number. If I type 3005, 3006 I get an error. Is this possible, or
am I stuck to one number at a time.

tia
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can't put multiple items in an IN () list from a pop-up parameter
prompt.

Here is a URL that has an example Query database. See the Query example
"How to create a parameter query that accepts a list of values."

http://support.microsoft.com/support/kb/articles/Q100/1/31.asp
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQd11KIechKqOuFEgEQI1iwCgr5balaYPUNG8OyfHJLlXfhlArYMAoL81
2ILBZzO9ii/cN9ixFYrAbxxD
=5Khg
-----END PGP SIGNATURE-----
 
Thanks! I'll check it out.

MGFoster said:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can't put multiple items in an IN () list from a pop-up parameter
prompt.

Here is a URL that has an example Query database. See the Query example
"How to create a parameter query that accepts a list of values."

http://support.microsoft.com/support/kb/articles/Q100/1/31.asp
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQd11KIechKqOuFEgEQI1iwCgr5balaYPUNG8OyfHJLlXfhlArYMAoL81
2ILBZzO9ii/cN9ixFYrAbxxD
=5Khg
-----END PGP SIGNATURE-----

How can I pass multiple values using the IN operator on a numeric field.
Example, the table is "Customer" and I want the user to be able to type in
"N" number of customer numbers to show only those customers. I tried using IN
([enter cust. number]) in the Criteria field but I can only type in one
customer number. If I type 3005, 3006 I get an error. Is this possible, or
am I stuck to one number at a time.
Click to expand...
Click to expand...
 
Back
Top