Param query

G

Guest

Hi - I've used your advice in creating a multiple parameter query allowing
the user to enter the parameters. I'm having a problem in that the
information returned is Ok except for one field which is a number field. In
this case it's giving me values of 1 and 5 where it should be 28 and 57. Any
suggestions? Below is how I've structured the query
SELECT *
FROM qryMFLicbyRO
WHERE (((InStr("," & [Enter FC # separated by commas no spaces] & ",","," &
[FCNo] & ","))>0));
 
A

Armando Blanco

Cheryl said:
Hi - I've used your advice in creating a multiple parameter query allowing
the user to enter the parameters. I'm having a problem in that the
information returned is Ok except for one field which is a number field.
In
this case it's giving me values of 1 and 5 where it should be 28 and 57.
Any
suggestions? Below is how I've structured the query
SELECT *
FROM qryMFLicbyRO
WHERE (((InStr("," & [Enter FC # separated by commas no spaces] & ",",","
&
[FCNo] & ","))>0));
 

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

Top