Non MR's and Blanks to show

[instereo911 via AccessMonster.com]

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.

 

[KARL DEWEY]

Try this ---
SELECT instero911.Date, instero911.Associate, instero911.Status,
instero911.StatusCode, instero911.Method
FROM instero911
WHERE (((instero911.Date)=[Enter parameter]) AND
((instero911.Status)<>"ROUTED") AND ((instero911.StatusCode)<>"MR" And
(instero911.StatusCode) Is Null)) OR (((instero911.Date)=[Enter parameter])
AND ((instero911.Status)="ROUTED"));

 

[John W. Vinson]

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.

Use a criterion on statuscode of

(<> "MR" OR IS NULL)


John W. Vinson [MVP]

 

[instereo911 via AccessMonster.com]

Thank you both.. It worked. I knew it was easy.. - Maybe I should go to beg
access school

Thanks again

Try this ---
SELECT instero911.Date, instero911.Associate, instero911.Status,
instero911.StatusCode, instero911.Method
FROM instero911
WHERE (((instero911.Date)=[Enter parameter]) AND
((instero911.Status)<>"ROUTED") AND ((instero911.StatusCode)<>"MR" And
(instero911.StatusCode) Is Null)) OR (((instero911.Date)=[Enter parameter])
AND ((instero911.Status)="ROUTED"));

Good afternoon,

[quoted text clipped - 20 lines]

Thanks everyone.