Access 97 Relative Date Query 1

[quickster2]

I have a single table that I need to provide a 13 rolling month report. I can create a query for each month & year, but I only want to create the queries for this once using a variable that will calculate the previous 13 months for me. I have tried the datrediff, dateadd, etc. in several different configurations and have failed miserably.

Any assistance would be apperciated.

Thanks

 

[ETID]

have you tried... dateadd("m",-13,date())

 

[quickster2]

Yes I have. Unfortunately, the months that I can go back is only in the current year.

 

[quickster2]

Also, the data returened from the query is only from one day rather than the entire month.

 

[ETID]

Hmmmm,.... I have no trouble with this in access 2k


adding this criteria to a date field ....

>=DateAdd("m",-13,Date())

 

[quickster2]

Almost there. When I added it, It returned all dates past the 13th month. I added the following and it returned only July & August of last year: <=DateAdd(&quot;m&quot;,-13,Date()) And >DateAdd(&quot;m&quot;,-14,Date()).

It also only listed dates up to today's date rather than the whole month.

Any other thought would be appreciated.

Thanks in advance.

 

[ETID]

Try this one....

>=DateAdd(&quot;m&quot;,-13,Month(Date()) & &quot;/1/&quot; & Year(Date()))

 

[ETID]

NO joy?

 

[quickster2]

Outstanging! Thanks for the help.