Re: Non MR's and Blanks to show

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Wed, 06 Feb 2008 00:14:25 GMT, "instereo911 via AccessMonster.com"
<u27979@uwe> wrote:

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

Relevant Pages

  • Re: Form tutorials?
    ... "John W. Vinson" wrote: ... know if anyone can point me to relevant tutorials. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.forms)
  • Re: Very Basic Question about Totaling
    ... "John W. Vinson" wrote: ... But I can't find how to use excel formulas in access. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.gettingstarted)
  • Re: Hiding dates Query fields
    ... "John W. Vinson" wrote: ... My query selects all the records that I want. ... John W. Vinson [MVP] ...
    (microsoft.public.access.gettingstarted)
  • Re: delete access 2007 database
    ... John W. Vinson [MVP] ... The databases are not on your disk. ...
    (microsoft.public.access.gettingstarted)
  • Re: I need help creating a popup message
    ... "John W. Vinson" wrote: ... The Access Web resources page: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.forms)