How to set query criteria based on # of characters in a field

[russi]

Maybe it's the day's 'brain drain', but I need to set a criteria in a query whereby it will select answers in a field that are a specific number of characters in length.
i.e., answers that are 5 digits long (without knowing any of the digits)

Russ

 

[Pat Hartman]

Select ...
From ...
Where Len(YourField) = [enter length];

 

[russi]

Thanks, Pat!

I'll try that.

Russ