Correct syntax for query expression

[stevekos]

Hello all. I work in a social program which calls clients daily in order to check on their welfare. These calls are made based on both pre-determined call days, and ad-hoc changes based on their changing circumstances. I am currently working on a new database for this service, and particularly a query expression to return a Yes/No value based on a number of conditions.



- Firstly a condition based on a date range derived from two fields: "NoCallFrom" and "NoCallTo."
- Secondly a condition based on a multi-select lookup field of days of the week.

I want my expression to:
- Based on today's date and day of the week, compare this with the From-To dates and then the values contained in the multi-select lookup field (multi selected for days requiring a call, e.g. Mon, Wed, Fri)
- and then determine whether the client requires a call based on today's date.

I have built an IIF expression which successfully deals with the From-To date range, CallToday?: IIf(Date()>=[NoCallFrom] And Date()<=[NoCallTo],"No","Yes") but that's where I am stuck. I am not sure how to construct the rest of the expression. I think that the 'Like' function should feature somewhere there, but that's where my knowledge is exhausted .

I would appreciate any help you can offer with this.

Steve.

[June7]

If by multi-select you mean a multi-value field, then LIKE will not be helpful because the data in the field is not a string. Review https://support.office.com/en-us/art...C-6DE9BEBBEC31