General discussion

Locked

In operator

By highlander718 ·
I'm trying to use the in operator in a query, so that the user can select the list of options. So instead of using : IN(op1,op2,..) I'm using IN([enter parameters]) so the users is prompted for values but it's only working with one parameter and nota list of them. I tried every possible variant to input the list but it's not working ( I got an empty result list).

Any idea ?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

In operator

by chainsawz In reply to In operator

Hi!

Go to microsoft's support page @ http://microsoft.com/support/ and enter article number Q100131 in the Knowledge Base Article Number search box. This article explains how to create a parameter In()Statement for multiple criteria.

I hopethis helps.

Collapse -

In operator

by highlander718 In reply to In operator

Thanks, it might work, but I don't have time for experiences in VB, as I'm not familliar with it. I was trying to use the simple IN function in Access query. Anyway I found a better solution in the mean time which also is much more elegant and user friendly.

Normally I would grant you the points anyway but it looks that there is something wrong with the reward on this page as I did not receive points in the last 2 month even if I'm loging in on a regular basis. Sorry,

Collapse -

In operator

by highlander718 In reply to In operator

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Software Forums