J
Jackson via AccessMonster.com
Hi,
I just want to get some thoughts on the best way to handle the following. I'm
going to be reconciling account holdings between one system and various
sources where they are held. I've got a query which does the basic
reconciliation which I've now based a form off.
The idea is for the user to open this form, can see where any Differences are
above zero (calculated in the query), enter any reconciliation amounts in one
field, enter notes in another field and then a calculated field would just be
the difference minus the reconciliation amount.
Thus for example, If the difference comes out to 5.50, the user finds it's
because commission was charged incorrectly, they'd enter -5.50 as the rec
amount, commission error in the notes and then the unreconciled field would
show 0. I'm trying to work out the best way conceptually of how these fields
should be stored, perhaps append them to a table which records the date and
the line item being reconciled so that if one were to look back at a
particular date it would show the manual entries that were saved.
I tried to add an unbound field onto my form (columnar based on rec query),
but if I entered 5.50 in the first row, it would add this amount to all
records - not sure why this is so...any thoughts, tips, advice would be
appricated!
Cheers.
I just want to get some thoughts on the best way to handle the following. I'm
going to be reconciling account holdings between one system and various
sources where they are held. I've got a query which does the basic
reconciliation which I've now based a form off.
The idea is for the user to open this form, can see where any Differences are
above zero (calculated in the query), enter any reconciliation amounts in one
field, enter notes in another field and then a calculated field would just be
the difference minus the reconciliation amount.
Thus for example, If the difference comes out to 5.50, the user finds it's
because commission was charged incorrectly, they'd enter -5.50 as the rec
amount, commission error in the notes and then the unreconciled field would
show 0. I'm trying to work out the best way conceptually of how these fields
should be stored, perhaps append them to a table which records the date and
the line item being reconciled so that if one were to look back at a
particular date it would show the manual entries that were saved.
I tried to add an unbound field onto my form (columnar based on rec query),
but if I entered 5.50 in the first row, it would add this amount to all
records - not sure why this is so...any thoughts, tips, advice would be
appricated!
Cheers.