J j0se Registered User. Local time Today, 16:17 Joined Jan 15, 2003 Messages 57 May 13, 2004 #1 Can I use the len function in a query's criteria field? I've tried a few things like: (len<4) [len<4] etc cheers for any help
Can I use the len function in a query's criteria field? I've tried a few things like: (len<4) [len<4] etc cheers for any help
N namliam The Mailman - AWF VIP Local time Today, 17:17 Joined Aug 11, 2003 Messages 11,695 May 13, 2004 #2 Yes you can however ... You have to make a seperate field Len([Yourfield]) and then in the criteria say <4 BR
Yes you can however ... You have to make a seperate field Len([Yourfield]) and then in the criteria say <4 BR
J j0se Registered User. Local time Today, 16:17 Joined Jan 15, 2003 Messages 57 May 13, 2004 #3 thanks namliam said: Yes you can however ... You have to make a seperate field Len([Yourfield]) and then in the criteria say <4 BR Click to expand... Thanks for that - I really appreciate it!
thanks namliam said: Yes you can however ... You have to make a seperate field Len([Yourfield]) and then in the criteria say <4 BR Click to expand... Thanks for that - I really appreciate it!
