simple?

[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 (e-mail address removed)
www.SuriSMS.com online support via (e-mail address removed)
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 : (e-mail address removed)

 

[Guest]

You're going to have to use a criteria like this: Like "A*"
OR like this: Len([Text Field]) = 5
Or even Like this: Like "A*" AND Len([Text Field]) = 5

I don't know if this is exactly what you'll need, but if you eperiment a
bit, you should be able to get the result you want.

BTW, if you can, check the access help file, it'S got a lot of good
expample. Just search for filter.

Good Luck

Steve

 

[HS Hartkamp]

Create an expression from the field, and put your criterium on that:
Expr1:Left(" "&[Yourfield],5)

Bas hartkamp