filter query

[NAS]

I have a query that contains SSN's. The SSN's contain 10 characters, the
first being a designator for branch of service or civilian. For example,
SSN's beginning with "0" belong to Marines, while SSN's starting with "N" are
Navy. What I need to do is filter out all Navy and Civilian personnel and
show only Marines. I have tried what I thought would work in the criteria row
but nothing is working. Please advise. Thank you.

 

[Tom van Stiphout]

On Fri, 9 Oct 2009 06:45:01 -0700, NAS <[email protected]>
wrote:

You need a wildcard search. Put this in the criteria field:
Like "0*"

-Tom.
Microsoft Access MVP