Help! Too Complicated - CheckIn/CheckOut

  • Thread starter Thread starter Jennay via AccessMonster.com
  • Start date Start date
J

Jennay via AccessMonster.com

Ok -

I'm creating a DB where we will be tracking actual audits done externally.
I was just informed that the auditors want to be able to "Check Out" the
audit once it is created (basically take the information for the audit with
them and Input the scores, etc. as they do it) and then when they return
from doing the audit they want to "Check In" the audit where the scores
they did while at the site are added back in to the Db. I don't even know
where to start! Does anyone know where I can get help on this? Also -
just let me know if you need me to explain further....
 
As you create the table (my example's name as tblAudit), use the primary key
function. Example: your table would have the fields AuditID (autonumber as
primary key),AuditSite (or whatever description you want to use to identify
the audit), Score. You can add as many fields as you want - maybe AuditDate,
Auditor, etc.

You can then export this table to another database for your auditors to take
with them. They can input the scores as appropriate. When complete, import
their table into your database (I would suggest changing the name to
tblAuditUpdated).

Create an update query where the field to be updated is Score (table
reference is tblAudit), and in the "Update To" box type in the following:
[tblAuditUpdate].[score]

This will update ALL records in your table with the scores from what the
auditors input. Use criteria to limit the update; for example, to update only
those audits that do not yet have scores input, the criteria would be Is Null.

If you are interested in historical tracking of your audit data, keep the
scores (and audit dates) in a separate table using AuditID as the relation
between the two tables.
 
Back
Top