Len function not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field. I am trying to find all the rows where this field is
less than 4. The function is not working. It does work if I look for all rows
where it is equal to 4. I have tried < 4, <"4" and < '4'. None of these work.
 
Assuming you've created a computed column Len([MyTextFIeld]), putting <4 as
the criteria for that field should return all rows where the len is 3
characters or less. Are you sure you have fields that meet that criteria?
 
I thought I did but apparently not. I am working with a test database. The
query is working now (now that I have appropriate test data in it!). Thanks.

Douglas J. Steele said:
Assuming you've created a computed column Len([MyTextFIeld]), putting <4 as
the criteria for that field should return all rows where the len is 3
characters or less. Are you sure you have fields that meet that criteria?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Michelle W. said:
I have a text field. I am trying to find all the rows where this field is
less than 4. The function is not working. It does work if I look for all
rows
where it is equal to 4. I have tried < 4, <"4" and < '4'. None of these
work.
Click to expand...
Click to expand...
 
Back
Top