S Shawny Registered User. Local time Today, 03:16 Joined Apr 15, 2000 Messages 64 Apr 18, 2003 #1 What is the criteria to filter records that have less than a certain length of text in some field? The text can be letters or numbers. Example: select all records where [address] has less than 40 characters. Thanks
What is the criteria to filter records that have less than a certain length of text in some field? The text can be letters or numbers. Example: select all records where [address] has less than 40 characters. Thanks
J Jack Cowley Registered User. Local time Today, 03:16 Joined Aug 7, 2000 Messages 2,639 Apr 18, 2003 #2 In the criteria line: Len([NameOfField]) <40 hth, Jack
