filtering query results

  • Thread starter Thread starter J-LL
  • Start date Start date
J

J-LL

Hello.
I'm querying a table that has a field containing data entries that have
varying character lenghts. Is it possible to filter the data having only two
characters long using Microsoft Query?
Thanks.
 
One approach might be to add a new field that is something like:

NewField: Len([YourField])

and add the criterion beneath it as:

2

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff,
I believe that will work in an Access query, but I can't see how it'll work
with the lower-featured Microsoft Query: something tells me it can't be done.
I originally posted this question in an Excel group but nobody replied, so I
thought I'd try it here. Sorry if I misled you.

Jeff Boyce said:
One approach might be to add a new field that is something like:

NewField: Len([YourField])

and add the criterion beneath it as:

2

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


J-LL said:
Hello.
I'm querying a table that has a field containing data entries that have
varying character lenghts. Is it possible to filter the data having only
two
characters long using Microsoft Query?
Thanks.
Click to expand...
Click to expand...
 
Back
Top