Double Entry

[N. Evar]

Hi. I am new to designing an Access database and one of the requirements is
that double entry can be performed on the "essential" data. Is there a way
to do double entry in Access?

Thanks.

 

[Jeff Boyce]

From an accounting standpoint, "double entry" helps to ensure that the same
totals are reached.

If you are having Access compute totals, I could see having the same numbers
entered twice to investigate that the data entry was accurate. However,
since BOTH data entry sessions could be incorrect, having the totals balance
doesn't ensure accurate data entry.

If you created a "temp table" to hold data entry, and included a person/id
for the data rows, you could compare persons' data entry before "posting" a
final permanent record. This is NOT built into Access however, you'd have
to create it.

Regards

Jeff Boyce
<Office/Access MVP>

 

[N. Evar]

So, I would have to create two temporary tables (for first entry and for
second entry) and have a macro compare the entries to ensure accuracy and
then have that output to a third table that is the resolved entry? OR just
one temp table that has two rows - one for the first entry and one for the
second entry?

I am coming from a research institution - so it is more like making sure
that a particular date was entered correctly (for example 01/29/2005 wasn't
entered as 02/28/2005).

Thank you for your input!

N Evar

 

[KARL DEWEY]

See my post to Jose in General Questions - Double data entry for data
validation

 

[Jeff Boyce]

A single table, with a data-enterer field to tell the data entry attempts
apart.

A pair of queries, one for each data-enterer's data.

An "unmatched" query, using the two previous queries (but not the enterer
info) to check for unmatched entry. NOTE: you'd need some way to uniquely
identify each "entry" row, or the unmatched query would find all other data
entry as not matching.