Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT EXPERT: DOES "IS ONE OF" HAVE A MAX?

Status
Not open for further replies.

lismiss

Technical User
Mar 23, 2002
5
US
I'm trying to use select expert "is one of" and I have 53 items that I want to list. It gives me an error after 50 so I'm thinking that there must be a maximum number that can be listed. Can anyone verify that?
thanks. Lismiss
 
It may be but really you can use this on an array of 1000 items so I can't see why this should be the case

Go directly to the Record Select formula instead and try this instead (I hate the Select Expert ^-^)

{table.value} in [value1,value2,...add all values...value53]

that should work fine
Jim

JimBroadbent@Hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top