K
Kevin
I am currently using Excel to log the number of service visits to customer
premises whilst pulling the customer details from Access. This works ok but I
would rather do it all in Access if possible.
I have looked at a few templates but found it confusing trying to work out
how they are built/designed.
My first design thoughts are: -
Use the existing TblCust that holds name, cost details etc.
Create a table that logs the number of visits per day, per customer
Create a form that populates the above table
Create a query that lists each customer, the total number of visits, cost
per visit, total amount billable per month.
Please advise if there is an easier way to achieve the above
Thanks
Brian.
premises whilst pulling the customer details from Access. This works ok but I
would rather do it all in Access if possible.
I have looked at a few templates but found it confusing trying to work out
how they are built/designed.
My first design thoughts are: -
Use the existing TblCust that holds name, cost details etc.
Create a table that logs the number of visits per day, per customer
Create a form that populates the above table
Create a query that lists each customer, the total number of visits, cost
per visit, total amount billable per month.
Please advise if there is an easier way to achieve the above
Thanks
Brian.