IIF statement for query

[JoeyGaspard]

I have a working IIF statement with multiple conditions in an Access query:
Points: (IIf([AbsentT]![AbDate]>=Date()-28 And [AbReason]="Unexcused","1",IIf([AbsentT]![AbDate]>=Date()-28 And [AbReason]="Late",".5",IIf([AbsentT]![AbDate]>=Date()-28 And [AbReason]="Left",".5",""))))

I need to add the criteria of a specific day (ex Monday), so it will basically say if all the above is true and the day = Monday or Saturday, then 1.5, else, as is in above statement, hope that makes sense!
I dont have a field that list the days of the week, but I am hoping Access is smart enough to know by the date?

In summary, I need to say if its less than 28 days from today, Unexcused, a monday or saturday, then 1.5, if not monday or saturday, then 1, and if absreason is Left, .5.

Im sorry if I havent explained this well. Thanks in advance for any help!

 

[JoeyGaspard]

Please cancel this quesion/thread! Thank you

 

[Micron]

I would suggest that your query calculated field should call a function that will return whatever value you need. If you need help with that, you probably need to clarify or hope that someone gets lucky with the interpretation. I had written more, but since you're asking for closure I'll leave my post at that.

 

[welshgasman]

Please cancel this quesion/thread! Thank you

Please supply your solution. It could help others?
That is what these forums are for after all?