Microsoft Access - Accounts Receivable Solution

[Guest]

I am looking to use Access to automate my accounts receibable cash
application, and provide reports of remaing open transaction, Unapplied
payments, and Payments that do not match the transaction amount. I have
multible charges and payments for a given transaction reference. I have the
Transaction and Payments in two simple excel spreadsheets. It is eash to add
monthly data to the Invoice and Payment tables. I need help with the querrys
to make this work.

 

[Aaron Kempf]

if you need help with the queries-- then tell us

 

[Guest]

Aaron, I need help with the queries. I'n not sure Access is my solution but
I'm willing to give it a go rather then doing it manually, which is a very
clumsy time consuming error prone process. I believe Access could be the
solution but my experience level is not high and I dont have anyone here that
is much help to me. Thus the message I posted. I would appreciate any help
I can get.

Bob