Good afternoon,

I have a table that shows the following text fields -

Date - Associate - Status - StatusCode - Method -
each of these fields are text fields (except for date is Date field)

I am trying to set up a query in design view to say the following:

For Date [parameter], group by associate, group by status (if the status does
not equal "ROUTED"), show only the statuscodes that are <>MR or BLANK.

My problem is the last statement. Basically what is happening when I say
"show me the non MR's" it is pulling all the non MR's but also disregarding
the blank fields. It is just pulling data that has something in it but i
don't want that.. i won't both... Non MR and BLANKS. The blank fields have no
data at all in em'. No Null, No 0, No space.

I am not sure how to pursue this but it is killing me.. probably the easiest
thing. Does that make sense..

Thank you everyone.

Thanks everyone.