user enters date; other dates calculated

[donnycarr]

I have created a text box on the form, formatted to Date/Time and with an Input Mask where the user inputs a certain date).

I now want to create some "boxes??" next to this with calculations to work out a date 4, 12 and 52 weeks previous to the date entered by the user. I will then get the queries to pick up these dates from the various boxes in order to select certain records.

If anyone can help it would be much appreciated, I am really struggling with this..

Thanks

...Donny

 

[Rich]

Look up the DateAdd Function there are many examples shown in the help files.
HTH