query in text field

[Vishal Sewkaransing]

Hi there
I have a text field with all different text like
A1000
A1
A 1000
A 10

what i want to do is filter only the fields with A1000 ( letter + numbers )
there are 1 to 4 numbers behind the letter
how do i achieve this?
any help is greatly appreciated
Thanks

--
V. Sewkaransing
www.SuriStar.com online support via [email protected]
www.SuriSMS.com online support via [email protected]
www.MobielPlezier.com

MOBILE , SMS & ICT Solutions

Dr. J.F. Nassylaan # 35 Boven
Office Hours 9.00 AM - 6.00 PM
Telefoon : +597-420094 / Mobiel : +597-8515544
Messenger : [email protected]

 

[kingston via AccessMonster.com]

Use [A-Z]### in your query as the search criteria. HTH.

 

[Jeff L]

You would need to set some criteria on your record source.

Where YourFieldName Like "[a-z]#*"

Hope that helps!

 

[kingston via AccessMonster.com]

Actually, that's [A-Z]# OR [A-Z]## OR [A-Z]###.

Use [A-Z]### in your query as the search criteria. HTH.

Hi there
I have a text field with all different text like

[quoted text clipped - 8 lines]

any help is greatly appreciated
Thanks

 

[kingston via AccessMonster.com]

One more time:

[A-Z]# OR [A-Z]## OR [A-Z]### OR [A-Z]####

Actually, that's [A-Z]# OR [A-Z]## OR [A-Z]###.

Use [A-Z]### in your query as the search criteria. HTH.

[quoted text clipped - 3 lines]

 

[John Spencer]

Since you sample data has A, Space, Numbers, I am assuming that you want to
screen out the fields with spaces.

Like "[A-Z]*" AND Not Like "?*[!0-9]*"

Starts with a letter and doesn't have any characters other than 0 to 9 in
the rest of the string