Date Calculation within a form 1

[simonjackson79]

Hi,

I am in the middle of designing a statistical reporting form with queries and reports that are based on dates entered within the form. I have virtually finished but I have one remaining problem and need some assistance.

I need to make a text box automatically calculate a date that is ten years earlier than another date entered within the form. Is there any way to do this?

Any help would be much appreciated.

Si

 

[lupins46]

Set the control source to:
= dateadd("yyyy",-10,myothertextbox)

 

[simonjackson79]

That's great, I can get this whole project finished today now. Have a star 'cos you are one!