Software

Ask something
Discussion Locked

In operator

0 helpful
3 replies

by highlander718

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 ?

3 replies

by chainsawz

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.

by highlander718

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,

This discussion is closed to new replies.