Status update query

  • Thread starter Thread starter rama
  • Start date Start date
R

rama

I am looking for some help and advice to finish my access database.
In my access database I got table called ‘tblJobs’. There are some
fields – ID, Date, Job, Priority, Status, JobNo, etc. There are 3
status (completed / progress / pending). Some of the jobs need days to
finish. Where as some finishes at the same day. I have a query called
‘QRY_progress’ which will list out the in progress jobs. But here I
have the problem ie. I got a job with a job number ‘500’ and job ID
‘1000’ (job ID is auto number). Today Status of Job Number 500 is
progress, but tomorrow it is completed. So what happens is this job
will be reflected in ‘QRY_Pending’ and ‘QRY_Completed’. What I wish to
do is to set the status of all the progress jobs to ‘completed’ once
the job is actually completed. How to do this automatically.
Rama
 
What signal should the computer receive to know that the job is 'actually
completed'.

Upon receiving that signal, you can trigger an update query to update the
status.
 
Back
Top