i have a series of clients that need work doing. each one has house work on at a different frequency. some weekly, some 2 weekly, some 6 weekly etc. in additional these clients have garden work on at a different frequency
I would like to be able to add these clients to a database, say the work required (usually more than one form of work) and the frequency for each work form. Eg. john Smith, garden, every 2 weeks starting 1st April until 1st October and then John smith, house, every 4 weeks starting 1st June until 1st December.
The work would only ever be weekly. There are about 6 types of work I provide.
I would then like to be able to run a query every week which would then list the name and the work required that particular week. Basically a complicated calendar reminder for multiple, different jobs for multiple clients.
Any ideas how to do this?
I would like to be able to add these clients to a database, say the work required (usually more than one form of work) and the frequency for each work form. Eg. john Smith, garden, every 2 weeks starting 1st April until 1st October and then John smith, house, every 4 weeks starting 1st June until 1st December.
The work would only ever be weekly. There are about 6 types of work I provide.
I would then like to be able to run a query every week which would then list the name and the work required that particular week. Basically a complicated calendar reminder for multiple, different jobs for multiple clients.
Any ideas how to do this?