K
KG113
I used the Order Entry template on Access 2003 to create an order database
for our community theatre.
On the Invoice: I would like to show a Cumulative Balance (Total Due -
Payments) of all of the orders placed by that particular customer. The
expression that is on the Order Entry Template returns the amount due ONLY
for that particular order, which is but I would like to add the cumulative
amount due also, which will be expressed as a negative (credit).
Reason being, we sell subcriptions that are paid in advance but the products
(using as ticket prices ie adult, child, etc) charged against that amount
will occur over 3 to 5 invoices. So the customer will get an order
confirmation for each show that they attend that will show them the credit on
thier account that they can use to book additional shows.
Any suggestions on how i can do this?
for our community theatre.
On the Invoice: I would like to show a Cumulative Balance (Total Due -
Payments) of all of the orders placed by that particular customer. The
expression that is on the Order Entry Template returns the amount due ONLY
for that particular order, which is but I would like to add the cumulative
amount due also, which will be expressed as a negative (credit).
Reason being, we sell subcriptions that are paid in advance but the products
(using as ticket prices ie adult, child, etc) charged against that amount
will occur over 3 to 5 invoices. So the customer will get an order
confirmation for each show that they attend that will show them the credit on
thier account that they can use to book additional shows.
Any suggestions on how i can do this?