Question Help me to resolve a problem

[jimd1768]

I have a table with customer details.

I want to produce a bill every month to the customer. It is a standard £5 fee but can vary.

I will also have to be able to add any outstanding payments to give a new total.

How do I produce the bills each month from the customer details.

Thanks for any assistance

 

[Trevor G]

You would need to use a query to do this, you can create an expression to add the £5 or percentage to the payment field and also set an expression to determine the month.

Then create a report (If printing) to use the query where you can specify which month to run off.

Trevor