RE: Query Criteria Help!!!

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

Your table design could be better, but I will not go into that as you have
many documents that can have many reviewers which gets a bit complicated for
a newbie.

A work around for your query is as follows.
Use the QBE query grid and in the first row of the criteria completed 1
field should say "No"
On the second row of the criteria for completed 2 field should say "No"
On the thrid row the criteria for completed 3 field should say "No"

Each row is basically saying OR.

Hope this helps.
Dylan Moran
Melbourne


"Nic" wrote:

> Newbie here so please be patient with me...........
>
> I have a table which has the fields document number, reviewer 1, completed
> (check box), reviewer 2, completed 2 (check box), reviewer 3, completed 3
> (check box). I would like to run a query that shows the reviewers who have
> not completed their review (i.e. show only those who's completed box is not
> checked).
>
> I have no idea on what criteria to enter to display only this information.
>
> Any help would be much appreciated........
>
> Thanks
> Nic
.

Relevant Pages

  • UM, USM, UKM, UPM shameful days ahead
    ... THES and their stupid methodology. ... follow their stupid criteria no need to go for ISO or other ... reviewers, mark my words next year we will be ranked differently. ...
    (soc.culture.malaysia)
  • Re: Filter Sort Annoyance
    ... If your selection criteria change, ... use the same query and modify it by changing the selection criterion. ... I'll suggest that further normalization may be needed. ... In a well-normalized data design, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Dynamic Query Criteria and returning all records (*)
    ... You'll find that after saving the query in design view, ... and saving queries like this in SQL view. ... criteria prior to running a query or a report. ...
    (microsoft.public.access.queries)
  • Re: Show all records
    ... When I re-opened it in design view. ... and everything after the OR was turned into another field at the end of the columns in the query, with IS NULL in its criteria. ... When you switch to some other view and then back to design view, Access will have rearranged things in the design grid and may have made it harder to make subsequent adjustments correctly. ...
    (microsoft.public.access.forms)
  • RE: Null or No Null values in a parameter query
    ... I can see that a field called 1 was added to my query with a ... "KARL DEWEY" wrote: ... Look at it in design view. ... I prompt the user for the date criteria. ...
    (microsoft.public.access.gettingstarted)