Help in Opening Report.

[Mubashir sabir]

I am trying to open a report with the below where clause to show the records from last 6 months. Doing it in VBA with a docmd, but getting an error. Can't figure out how to do it. Please help. I am kind of new to this.



DoCmd.OpenReport "Master Pre-Op Patient Report", acViewReport, , "[Initial Consult Date] >= DateAdd(" & "m" & ",-6,Date())"

Thanks

[Mubashir sabir]

I've tried just using:
DoCmd.OpenReport "Master Pre-Op Patient Report", acViewReport, , "[Initial Consult Date] >= DateAdd(m,-1,Date())"

but both methods pop up a box asking me to input something for m. If I just enter m in the pop up box it works. But I don't want the pop up box to show up.

[IrogSinta]

Try this:
DoCmd.OpenReport "Master Pre-Op Patient Report", acViewReport, , "[Initial Consult Date] >=#" & DateAdd("m",-1,Date()) & "#"

Ron

[Mubashir sabir]

That worked great. Thanks!