Apr 24, 2002 #1 cathyg18 MIS Mar 12, 2001 54 US Is there a limit to the number of items that can be included in a TABLE.FIELD IN ['1', '2', '3', etc...] record selection formula?
Is there a limit to the number of items that can be included in a TABLE.FIELD IN ['1', '2', '3', etc...] record selection formula?
Apr 24, 2002 #2 Ngolem Programmer Aug 23, 2001 2,724 CA I would hazard a guess at 1000 which is the maximum size of an array Jim JimBroadbent@Hotmail.com Upvote 0 Downvote
Apr 25, 2002 #3 chelseatech Instructor Aug 25, 2001 1,812 NZ DOn't forget, you can also use ranges which might reduce the number of elements... TABLE.FIELD IN ['01' to '36', '38', '42', '45' to '67', etc...] Editor and Publisher of Crystal Clear http://www.chelseatech.co.nz/pubs.htm Upvote 0 Downvote
DOn't forget, you can also use ranges which might reduce the number of elements... TABLE.FIELD IN ['01' to '36', '38', '42', '45' to '67', etc...] Editor and Publisher of Crystal Clear http://www.chelseatech.co.nz/pubs.htm