Hello all, my first query here )).
I run a window cleaning business I'm using the services template with Access to produce invoices and quotes.
Because it's window cleaning, a lot of clients want work done on a regular basis. I've added some additional fields in the "customers" table. They are for: date of the last job done, how often they want the work done, and when they want it done again.
Whenever I send an invoice, I update the date of the last job field. The field that shows when they want it done again is a calculated field. It automatically calculates when the job will be done again based on how often it is to be done per year.
What I want to know is this:
Is it possible to get the "date of the last job" field to automatically update by watching the invoice table. As soon as the customer name is spotted, it will automatically enter the date of the latest invoice in the customer table.
I did this Excel, but don't know how to do it with Access.
Thanks everyone. Really appreciate it if you could help.
Cheers