Query Criteria Help!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Dylan,

Thanks that worked great but one more thing........

Some documents are only reviewed by one or two people and therefore the
reviewer 2 and reviewer 3 field are not always used. Can I get the query to
only select fields that have data in them and leave out the blank fields?

Your help is kindly appreciated.
Nic
 
Dylan,

Just had a thought......

It would be better if I could run a report on this information. I have two
other fields in the table, comment due and all comment returned (ie the
review process is closed at that date). Can I create a report that pulls all
document that do not have any entry in the comments returned field but
highlight the reviewers who have not completed their review in red (for
example)?

Am I trying to get too tricky here? Is there any easier way of doing this?

Your assistance is greatly appreciated.

Thanks a bunch
Nic
 
Back
Top