Query not counting

[Rpm1957]

i am trying to run a query based on 2 fields one is called REGION and contains records such as NW1,NW2,SE1,SE2, etc. The other is called OFFICE and contains records such as SLA, NON SLA.
What i am trying to achieve is to count how many NW records are SLA and how many are NON SLA.
I am not interested whether they are NW1or NW2 just NW.
I have tried using the Count function on the OFFICE field i.e like "sla" and it appears to work although i get two rows NW1 and NW2 which I don't want. But when i add a third column to the query for "non sla" i get no results at all?
Please Help

 

[plog]

The real problem is your data isn't structured properly. Every discrete piece of data needs to go into its own field. It sounds like "NW" should be in its own field and then the numeric part should be in another field. Fix that and your query becomes trivial.

 

[Rpm1957]

nw actually stands for Northwest followed by an address i just thought it was easier to call them NW1,NW2 etc for the purpose of this inquiry rather than fill the page with addresses.

 

[plog]

My analysis stands. You still have 2 distinct pieces of data in that one field, instead of a numeric part its now a text part that you need to extract out and make 2 fields.