chancer1967
Excel jockey
- Local time
- Today, 14:50
- Joined
- Mar 31, 2004
- Messages
- 28
A have (finally!) successfully created a form/subform that lists invoices by customer.
A combo box lists all the customers, and the subform lists all invoices for the specified customer, with invoice value, payments received and a calculated net balance (invoice value less payments)
Over time a lot of the invoice balances will become zero as payments are received. In order to reduce the number of items in the subform, I would like a checkbox in the form to exclude zero balances.
If ticked, that would filter out all records with a zero in the calculated balance.
How would I do this?
A combo box lists all the customers, and the subform lists all invoices for the specified customer, with invoice value, payments received and a calculated net balance (invoice value less payments)
Over time a lot of the invoice balances will become zero as payments are received. In order to reduce the number of items in the subform, I would like a checkbox in the form to exclude zero balances.
If ticked, that would filter out all records with a zero in the calculated balance.
How would I do this?
