How to log whether the dates between 2 fields >2 days apart

[Aimee]

I have a database which has 2 fields, 'date received' and 'date actioned'. I want to create another field which atomatically logs (yes or no) whether the date between the two is over 2 days.



Can anyone tell me what the expression would be, and how I would go about this?

Thank you

[RuralGuy]

You do not need, nor should you have another field in the table. It would simply be a calculated field in a query of the table. Have you tried that yet?

[Bob Fitz]

I have a database which has 2 fields, 'date received' and 'date actioned'. I want to create another field which atomatically logs (yes or no) whether the date between the two is over 2 days.

Can anyone tell me what the expression would be, and how I would go about this?

Thank you

Something like:
Iif(DateDiff("d", [date received] , [date actioned])>2,True,False)
But I would not save the result in a table. Calculations should not normally be saved.