Statements to customers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning! I think I may have a design problem but maybe you guys can help. I have 4 tables (Jobs, JobDetails, Payments, PaymentMethods. I have a button from a jobs form that displays an invoice showing amount outstanding and amount paid. What is the best way for me to run a query that shows all outstanding amounts and to print a statement on a monthly basis (or whenever I choose) for each customer with a outstanding balance?
 
Hi There,

Create the query with the information you want, and then
create an auto report using that query. You will need to
alter the report into a statement format using your design
funtion, then add the end you can set up a button on your
main form to generate the statements. Remember to add your
page break in after each client/job etc or they will all
appear on one instead of individually.

Nick, Glasgow Scotland

-----Original Message-----
Good Morning! I think I may have a design problem but
Click to expand...
maybe you guys can help. I have 4 tables (Jobs,
JobDetails, Payments, PaymentMethods. I have a button from
a jobs form that displays an invoice showing amount
outstanding and amount paid. What is the best way for me
to run a query that shows all outstanding amounts and to
print a statement on a monthly basis (or whenever I
choose) for each customer with a outstanding balance?
 
Back
Top