Visit Log

[zashmore]

Hi All,

My boss has asked me if I can change the visit log spreadsheet into a database to provide better reporting of time.

I have attached an image of the spreadsheet and I need to turn this into a dbase. To be honest I have been racking my brains trying to think how to do this.

I know how to calculate working days and simple calculations such as target visits and no. available days for visits etc.. but I need to be able to do it on a month by month basis and not too sure if Access can.

Any ideas on how to start?

Thanks

 

[pturco]

If you add a date field to the database table you can run queries to extract the information by month. You would place a criteria in the date field of the query. For example "Between [Start of Month] and [End of Month]".