Status update query

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
 
S

S.Clark

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top