M
myxmaster
I hope this is not to long winded and is clear in the objective:
Project:
I have a table called customers with basic name address etc.
I have a table called transaction type that has cash, check, credit
card .
I have a table called transactions that has date, transaction type,
amount, check number.
I have a table called limits that has limit
Goal:
I would like to create a form that brings up a customer, has the
option to choose cash, check, credit, once the option is made shows
all transaction records in that category, and reflects balance.
I have created a form with a subform that shows all transactions for a
customer, however it does not break each category down and show the
balance. I understans how to show calculations on a form.
TIA
Project:
I have a table called customers with basic name address etc.
I have a table called transaction type that has cash, check, credit
card .
I have a table called transactions that has date, transaction type,
amount, check number.
I have a table called limits that has limit
Goal:
I would like to create a form that brings up a customer, has the
option to choose cash, check, credit, once the option is made shows
all transaction records in that category, and reflects balance.
I have created a form with a subform that shows all transactions for a
customer, however it does not break each category down and show the
balance. I understans how to show calculations on a form.
TIA