display previous, current, next month 1

[topwaya]

Hi,
I have a query that displays the ProgPlanD (program plan date) that is between a date range in a form. I would also like it to display the previous and next month program plans.

The program plan date will always be one row on the first of each month.

Here is my query:

SELECT tblProgramPlan.ProgD, tblProgramPlan.NLProg, tblProgramPlan.NLStaff, tblProgramPlan.STProg, tblProgramPlan.STStaff, tblProgramPlan.WBProg, tblProgramPlan.WBStaff
FROM tblProgramPlan
WHERE (((tblProgramPlan.ProgD) Between Forms!fdlgOps!txtStart And Forms!fdlgOps!txtEnd));

How do I also get the previous and next month to display? I found the DateAdd stuff, is that what I use? And do I put it in the WHERE statement? I can't figure out the correct syntax.

Thank you!!!

 

[ZmrAbdulla]

Something like this

WHERE (((tblProgramPlan.ProgD)) Between Dateadd("m",-1,Forms!fdlgOps!txtStart) And Dateadd("m",+1,Forms!fdlgOps!txtEnd)));

Not tested...

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[topwaya]

The following works like a charm!! Thank you so much!!!

SELECT tblProgramPlan.ProgD, tblProgramPlan.NLProg, tblProgramPlan.NLStaff, tblProgramPlan.STProg, tblProgramPlan.STStaff, tblProgramPlan.WBProg, tblProgramPlan.WBStaff
FROM tblProgramPlan
WHERE (((tblProgramPlan.ProgD)) Between Dateadd("m",-1,Forms!fdlgOps!txtStart) And Dateadd("m",+1,Forms!fdlgOps!txtEnd));