Non MR's and Blanks to show

  • Thread starter instereo911 via AccessMonster.com
  • Start date
I

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.
 
K

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"));
 
J

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.
Click to expand...

Use a criterion on statuscode of

(<> "MR" OR IS NULL)


John W. Vinson [MVP]
 
I

instereo911 via AccessMonster.com

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

Thanks again

KARL said:
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,
Click to expand...
[quoted text clipped - 20 lines]
Thanks everyone.
Click to expand...
Click to expand...
 
Top