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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Michelle W." <(E-Mail Removed)> wrote in message
news:A64A67BA-C4ED-4F77-889E-(E-Mail Removed)...
>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.

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" wrote:

> 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
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Michelle W." <(E-Mail Removed)> wrote in message
> news:A64A67BA-C4ED-4F77-889E-(E-Mail Removed)...
> >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.
>
>
>