S
shi177
Can anyone suggest a good reference (book or otherwise) for writting VB
module within Access for matching and then marking transactions?
I have 2 tables, one with debits and other with credits. Some common fields
are cost center, account and transaction amount. Within the tables there can
be multiple debits or credits of the same dollar amount. What I need to do
is start with record 1 in debit table and go through records in credit table
until same $$ is found where the cost center and account in credit also
match the cost center and account of the debit amount transaction. Then mark
(flag) both records as "complete". Then move to record 2 in debit table and
move through credit table looking for same dollar amount - cost center -
account combination, but ignoring any credit transactions previously
"flagged". If no matching $$ is found in credit table for a debit, then move
to next debit record without flagging and repeat above search for matching
credit transaction.
Note: Other than cost center, account and amount there would not be any
other possible fields to match.
Thanks-----
module within Access for matching and then marking transactions?
I have 2 tables, one with debits and other with credits. Some common fields
are cost center, account and transaction amount. Within the tables there can
be multiple debits or credits of the same dollar amount. What I need to do
is start with record 1 in debit table and go through records in credit table
until same $$ is found where the cost center and account in credit also
match the cost center and account of the debit amount transaction. Then mark
(flag) both records as "complete". Then move to record 2 in debit table and
move through credit table looking for same dollar amount - cost center -
account combination, but ignoring any credit transactions previously
"flagged". If no matching $$ is found in credit table for a debit, then move
to next debit record without flagging and repeat above search for matching
credit transaction.
Note: Other than cost center, account and amount there would not be any
other possible fields to match.
Thanks-----