P
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.
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.