Help with formula problem

[Guest]

I have a large database with accounting relevant information. New data must
be appended in a particular format for export to the accounting department.
There are 26 inter-company transfer accounts that always remain the same
except for the debits and credits. I have placed them in a separate table.
Two fields identify the codes for the transfers, i.e., an account number and
the corresponding transfer account. When one of the accounts is debited, the
corresponding account must be credited by the exact same amount (the debit is
entered as a positive number, and the credit as a negative). I would like to
have the corresponding account credited when the debit amount is entered. For
example, Field1=Entity, Field2=account. Let's say entity number 08101 is
debited +20,000.00; then the corresponding account, say 08001 must be
credited -20,000.00. Can I put this in some simple code for the debit and
credit fields? I know how to do this in Excel, but I don't know if it is
doable in Access. Essentially then, this table with its monthly transfers is
appended to the "holding" table that exports a delimited file to the
accounting department.

 

[adsl]

I have a large database with accounting relevant information. New data must
be appended in a particular format for export to the accounting
department.
There are 26 inter-company transfer accounts that always remain the same
except for the debits and credits. I have placed them in a separate table.
Two fields identify the codes for the transfers, i.e., an account number
and
the corresponding transfer account. When one of the accounts is debited,
the
corresponding account must be credited by the exact same amount (the debit
is
entered as a positive number, and the credit as a negative). I would like
to
have the corresponding account credited when the debit amount is entered.
For
example, Field1=Entity, Field2=account. Let's say entity number 08101 is
debited +20,000.00; then the corresponding account, say 08001 must be
credited -20,000.00. Can I put this in some simple code for the debit and
credit fields? I know how to do this in Excel, but I don't know if it is
doable in Access. Essentially then, this table with its monthly transfers
is
appended to the "holding" table that exports a delimited file to the
accounting department.