Calculating credits for customers

[paperbag]

I have an access database where there are customers and they can receive
credits for working at the business. Their credits can be applied to any of
the purchases they make. Everytime they do a job to receive credit I want a
form to enter that day's credit with description of what they did under their
customer id and I want it to calculate all the credits they have on their
customer form. At the same time I want to show amounts of purchase and have
it deduct from their credits on a different form so I can calculate if they
will have out of pocket expenses. I suggested just using quickbooks to do
this but they insisted on having it on an access database.

 

[John W. Vinson]

I have an access database where there are customers and they can receive
credits for working at the business. Their credits can be applied to any of
the purchases they make. Everytime they do a job to receive credit I want a
form to enter that day's credit with description of what they did under their
customer id and I want it to calculate all the credits they have on their
customer form. At the same time I want to show amounts of purchase and have
it deduct from their credits on a different form so I can calculate if they
will have out of pocket expenses. I suggested just using quickbooks to do
this but they insisted on having it on an access database.

Ok. Do you have a question?

We cannot see your computer, we do not know anything about your table
structure, and we're unpaid volunteers donating time to help people get around
specific, defined problems. It sounds like you're asking us to create the
entire Access application for you. That's a bit beyond the bounds.

You would create a query (probably a Totals query) summing the credits from
whatever table they're in and displaying the result on a form, and - perhaps
using another subform - summing the purchases.

John W. Vinson [MVP]