Philocthetes
Has a great deal to learn
- Local time
- Today, 14:01
- Joined
- Dec 19, 2017
- Messages
- 28
Hi, all,
I'm trying to pull rows where the string length in the target field is less than 10 characters. I thought this should work:
LEN([TABLENAME].[FIELDNAME]) < 10 entered in the Criteria row for the target field. Access 365 puts "" around the number 10 and yields no results. All the examples I've found do not have quotes around the number and none are specific about how/where to put the expression in Query Design View.
Any help would be much appreciated.
I'm trying to pull rows where the string length in the target field is less than 10 characters. I thought this should work:
LEN([TABLENAME].[FIELDNAME]) < 10 entered in the Criteria row for the target field. Access 365 puts "" around the number 10 and yields no results. All the examples I've found do not have quotes around the number and none are specific about how/where to put the expression in Query Design View.
Any help would be much appreciated.