Complicated IIF?

[Sweetnuff38]

I need to do the following but need direction on how to make it all work.

Convert OperationsDate to a number (day of week – in query.. call it WeekDayNumber )

IIf OperationsDate (in Dispatch Table) is greater than or equal to EffectiveFrom (in Schedules Table) and Less than or equal to EffectiveTo (in Schedules Table) AND



IIF WeekDayNumber (in qrySchedules) equal to a value (ie: 123----, ---45--, -----67 etc) in DaysofOperation (in Schedules table)

Then run update query to return all records that apply....to a tblTemp

help... please....

[rpeare]

weekday([fieldname]) will return an integer value for the day of the week, bu default sunday is day 1 of the week, but it can be changed, so if you wanted monday to be 1 you could have

weekday([fieldname],2), in essence telling access you want day 2 to be counted as day 1.

I don't follow what you are trying to say but weekday is the function you're after to return a numeric value.