Is there a way to pull records where one of the fields has 1000 or less characters? Thank you, JA
J JA Jul 28, 2004 #1 Is there a way to pull records where one of the fields has 1000 or less characters? Thank you, JA
I Immanuel Sibero Jul 29, 2004 #2 Hi JA Use a select query with criterion: Len([SomeField]) <= 1000 Also, consult the help facility regarding Trim, LTrim, and RTrim if leading or trailing spaces in the field matter to you. HTH, Immanuel Sibero
Hi JA Use a select query with criterion: Len([SomeField]) <= 1000 Also, consult the help facility regarding Trim, LTrim, and RTrim if leading or trailing spaces in the field matter to you. HTH, Immanuel Sibero
