How can I query or sort on just a 5 numeric entries in a field?

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

Guest

Hello,

I am new with Access and I need to query on a field with only 5 numbers in
it. For example, my columns has 5, 6, & 7 numbers in it and I just need all
the entries with 5 entries in it.

Thanks so much!
 
I should be more clear. I have 5433 & 54345 in the same column, but in
different fields. I have 4 number entries and 5 number entries. I just want
all of the 5 number entries from my table.

Thanks for any help.
 
Hello,

I am new with Access and I need to query on a field with only 5 numbers in
it. For example, my columns has 5, 6, & 7 numbers in it and I just need all
the entries with 5 entries in it.

Thanks so much!
Click to expand...

I *think* that a criterion of

LIKE "#####"

will work... if you mean that you have a field containing values like

31234
1231234
123123
12312
53132
123556

this will return only those records where the field contains
five-digit numbers. If I've misunderstood please post back.

John W. Vinson[MVP]
 
Back
Top