reprot query questions

[dhsdhs]

This is very hard to explain, I want the report to do, but here goes.
This is what the query looks like:

SELECT tblAPPLICATIONS.[DATE RECEIVED], tblAPPLICATIONS.MEMBER, tblAPPLICATIONS.SSN, tblAPPLICATIONS.SPECIALIST, tblAPPLICATIONS.[DAYS OLD], IIf(tblAPPLICATIONS.[DATE RECEIVED]<= Date() - 182, "Period1", IIf(tblAPPLICATIONS.[DATE RECEIVED]<= Date() - 152, "Period2", IIf(tblAPPLICATIONS.[DATE RECEIVED]<= Date() - 122, "Period3", IIf(tblAPPLICATIONS.[DATE RECEIVED]<= Date() - 92, "Period4", IIf(tblAPPLICATIONS.[DATE RECEIVED]<= Date() - 62, "Period5", IIf(tblAPPLICATIONS.[DATE RECEIVED]<= Date() - 32, "Period6","Older")))))) As Period
FROM tblAPPLICATIONS
WHERE (((tblAPPLICATIONS.REPORTS)="TIME AGING")) And (((tblAPPLICATIONS.[DATE RECEIVED])<=Date()-32));

So the complete report contains groups of cases that are 6 months or more old today, one month from today, two months from today, three months from today, etc.....

Right now each group is name Period 1, Period 2, Period 3, etc.
I would like them to be named
Period 1 Today -----------------------------------03/07/2003
Period 2 the date 30 days from today ----------04/06/2003
Period 3 the date 60 days from today ---------- etc.
Period 4 the date 90 days from today etc.
Period 5 the date 120 days from today etc.
Period 6 the date 150 days from today etc.

And the dates would change based on what the date is when the report is run.

Can this be done and how do I do it?

 

[Cassio]

You can use this to show the date you want:

Period 1 = DateAdd(DateInterval.Month, 1, Now)
Period 2 = DateAdd(DateInterval.Month, 2, Now)

or

Period 1 = DateAdd(DateInterval.Day, 30, Now)
Period 2 = DateAdd(DateInterval.Day, 60, Now)