stevekos07
Registered User.
- Local time
- Today, 15:30
- Joined
- Jul 26, 2015
- Messages
- 174
Hi all, I asked about this problem in a previous post, and after not receiving any definite solution I got thinking about it further.
Previous post link http://www.access-programmers.co.uk/forums/showthread.php?t=279542
added by JDraw
My aim is to produce a report daily which shows which clients require a call based on:
- Selected days of the week where they do not want a call (e.g. no call on a Monday, Wednesday and Sunday).
- Ad-hoc periods when they do not want a call (e.g. No call from xxx to xxx).
- Call any day where either above does not apply.
This kind of situation is simillar to say what would apply to managing a newspaper delivery round or milk run etc. In our case we run a service calling elderly frail people at home every day to check on their welfare.
I started out with trying a multi-value field to select the days not to call, but dealing with multi-value fields in queries seems to be quite a challenge. So I have gone down a different track. I have set up in my clients table a field for each day of the week as a Yes/No field, and then have 7 separate queries which can be run applicable to each day of the week (our service operates 365 days/year).
This seems to work well. I can run each query to produce a report based on the day of the week.
My next challenge is to produce a form command button to run the query applicable to today based on the day of the week (ie. if today is a monday it will run the qryMondayCalls query etc.).
Can someone help with how to set up such a button in a form?
Previous post link http://www.access-programmers.co.uk/forums/showthread.php?t=279542
added by JDraw
My aim is to produce a report daily which shows which clients require a call based on:
- Selected days of the week where they do not want a call (e.g. no call on a Monday, Wednesday and Sunday).
- Ad-hoc periods when they do not want a call (e.g. No call from xxx to xxx).
- Call any day where either above does not apply.
This kind of situation is simillar to say what would apply to managing a newspaper delivery round or milk run etc. In our case we run a service calling elderly frail people at home every day to check on their welfare.
I started out with trying a multi-value field to select the days not to call, but dealing with multi-value fields in queries seems to be quite a challenge. So I have gone down a different track. I have set up in my clients table a field for each day of the week as a Yes/No field, and then have 7 separate queries which can be run applicable to each day of the week (our service operates 365 days/year).
This seems to work well. I can run each query to produce a report based on the day of the week.
My next challenge is to produce a form command button to run the query applicable to today based on the day of the week (ie. if today is a monday it will run the qryMondayCalls query etc.).
Can someone help with how to set up such a button in a form?
Last edited by a moderator: