INLIST

[Ncholie]

[updated:LAST EDITED ON Dec-13-05 AT 04:00 PM (EST)]I need to use INLIST. But, I need to use a field as the list. I am using SQL server 2000 and Visual Basic. I am populating a field called C1 with this list - ^12 - THIS IS A TEST^ , ^2342 - TEST^ , ^4574 - TEST2^ , ^5685 - TEST4^ , ^5687 - TEST3^ , ^800 - THIS IS A TEST^ , ^AAAA - ANOTHER TEST^ , ^BBBB - OK ANOTHER TEST^. ____So my caculation looks like Inlist(Officecode, c1). This doesn^t seem to work. I have to use this because the string will change, depending on what the user chooses. To make is work, I have to put the actually list in, so the calculation looks like this - __Inlist(Officecode, ^12 - THIS IS A TEST^ , ^2342 - TEST^ , ^4574 - TEST2^ , ^5685 - TEST4^ , ^5687 - TEST3^ , ^800 - THIS IS A TEST^ , ^AAAA - ANOTHER TEST^ , ^BBBB - OK ANOTHER TEST^)______Whey can^t I use the field, C1?__I am using version 8.1.

[kfleming]

What about using the expression:__Officecode$c1____This expression will return a true value when the current value of Officecode is contained in the string c1.____Kathleen__R&R Support____