I have a DB with 150 customers. I would like to print a report each month that acts as their invoice. I am looking to get 2 customers details per page in the following format:
CustID: 15
Month: Apr 10
Name Surname: John Smith
AmountDue: £7.50
AmountOutstanding: £5.00
Total: £12.50
I currently have this on excel but it is a long manual process. Can this be done in Access.
I am new to access so would require easy to understand answers if possible.
Thank you in advance
CustID: 15
Month: Apr 10
Name Surname: John Smith
AmountDue: £7.50
AmountOutstanding: £5.00
Total: £12.50
I currently have this on excel but it is a long manual process. Can this be done in Access.
I am new to access so would require easy to understand answers if possible.
Thank you in advance