How to check for all lines to be "Done"?

  • Thread starter Thread starter Emilio
  • Start date Start date
E

Emilio

Hi all,

I have a subform with 3 fields:

Scheduled, JobDate and Status
I used it to keep track of when a job is "Done" so the
job can be added to a list of outstandings.
The problem is if I have say 2 lines (sometimes are 35):

Jones 08/15/03 Done
Jones 08/18/03 InstallerTold
(this all will show in a calendar for scheduling)
automatically this job will show as outstanding even if
it is not all completed.
Is there a way to create a query that checks ALL lines to
see if ALL is "Done"?

Thanks for any help,
Emilio
 
Hi all,

I have a subform with 3 fields:
Click to expand...

Slight but important correction: you have a Subform with three
controls, bound to a Table (or a Query) with three fields. A Subform
or a Form is *just a window* and does not contain any data.

Is there a way to create a query that checks ALL lines to
see if ALL is "Done"?
Click to expand...

It's easy in a Table (again, a subform is not a table):

SELECT * FROM yourtable
WHERE JobID = <the job you want to check>
AND Status <> "Done";

If this returns any rows the job's not DONE.
 
Thanks a lot for your help.

Emilio







-----Original Message-----


Slight but important correction: you have a Subform with three
controls, bound to a Table (or a Query) with three fields. A Subform
or a Form is *just a window* and does not contain any data.

It's easy in a Table (again, a subform is not a table):

SELECT * FROM yourtable
WHERE JobID = <the job you want to check>
AND Status <> "Done";

If this returns any rows the job's not DONE.


.
Click to expand...
 
Back
Top