Query Parameters

  • Thread starter Thread starter duckslikejello
  • Start date Start date
D

duckslikejello

I am having trouble with my query. I know how to request one piece o
info from the user

[Enter Acct Number

But...How would I go about asking for multiple Acct Numbers and the
have the user end the criteria by just entering nothing

For Example

1) 12
2) 45
3) 78
4) 14
5) (nothing, just press enter

Thanks for the help
 
duckslikejello said:
I am having trouble with my query. I know how to request one piece of
info from the user.

[Enter Acct Number]

But...How would I go about asking for multiple Acct Numbers and then
have the user end the criteria by just entering nothing.

For Example:

1) 123
2) 456
3) 789
4) 147
5) (nothing, just press enter)
Click to expand...


I think this is a poor approach and would be very difficult,
if not impossible, to accomplish.

A little better way to be to prompt the user for the list
separated by commas (e.g. 123,456,789,147). This situation
can be done using a criteria like:

InStr("," & [Enter list] & ",", "," & [Acct Num] & ",") > 0
 
Back
Top