Rolling a Date Back 12 Months Question

[rmoreno]

I have a query that takes a date from a selection form. Is there a way to window my data by taking this date and going back 12 months to give me a block of data covering this 12 month window.

Example:
Date entered is 03/dd/06
Date window desired is 04/01/05 thru 03/14/06

 

[RuralGuy]

Look up DateAdd() in VBA help.

 

[rmoreno]

I am using Access 97, I tried looking for the DateAdd function and could not find anything. Is this function available in Access 97? If not, is there a work around.

 

[RuralGuy]

I don't know what functions are in ac97. See if this link has anything you can use. Date/Time: Index of Articles Also if you start a new thread with "ac97 replacement for DateAdd()" or something like that as the subject, there are ac97 guru's here that love to create those functions.