DateAdd Function

[banno1]

Hi


I am trying to figure out how to use the DateAdd function to work out the date 26 weeks following the date in a different field

e.g. I would like the field "RTT" to use the date from the "DateReferred" field to show what the date would be 26 weeks after the "DateReferred".

I have done some extensive reading but haven't got very far! I have deduced this can only be done with a Query but can't figure out how I can go about it.

Thank you very much in advance for any help you can give!

[June7]

Try:
DateAdd("ww", 26, [DateReferred])

Expression in query or textbox.