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));
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));