filtering query results

[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.

 

[Jeff Boyce]

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]

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.

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

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.