Let's call my talbe journal. My relevant fields are entity, account, amount,
and DorC. My talbe is the result of several append queries. I then can run a
query on it that shows me the sum of amounts for entities and wheter the
amount is a debit or credit (DorC).
Twenty-six records in the table are used for transfers. From the view
provided by the query on the sum of entities, I transfer each of thirteen sum
amount debits to two corresponding transfer accounts on the journal table.
It works like this: the amount of the transfer will be the exact amount
corresponding to a specific entity on the sum of entities query. In the
journal table, those sums are tranfered to an account whose last five digits
correspond to the sums entity number. That amount entry is positive and a D
must be entered in the debit or credit field.
A corresponding transfer account whose entity number is the same as the last
five digits of the debit must receive the negative of that amount and C in
the debit or credit column. I hope this isn't too confusing.
e.g.,
Talbe: journal
Fields: entity, acct, amt, dorc
08001, 12408001, --- , -
Query: sums
Fields: entity, SumOfamt, dorc
08001, $470,000.00, D
Transfer accounts in Table journal:
Fields: entity, acct, amt, dorc
08101, 12408001, (the SumOfamt), (D)
08001, 12408101, (neg. SumOfamt), (C)
Can someone help me fashion some code that will automate the transfers? I've
been trying to use DLookup, but I'm having some trouble with it.
|
Similar Threads
