Hi
I'm new to VBA. I'm opening a report using VBA. The last parameter of the following line is the where clause:

DoCmd.OpenReport "rpt_facilityVisitorComplaintInformation", acViewPreview, (having clause)

I'm just wondering that is there any way that I can use having clause while opening the report.

Actually it's

DoCmd.OpenReport "rpt_facilityVisitorComplaintInformation", acViewPreview, (filter), (having clause)

Or WHERE clause. The filter can be left out but you must include the extra comma if you leave it out. Yes, you can have a WHERE clause. What exactly do you want yours to be?

strWhere = "your criteria here"
DoCmd.OpenReport "rpt_facilityVisitorComplaintInformation", acViewPreview, , strWhere


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division