Multiple Criteria Report

[outlaw318]

I have a form that runs a report using the dates entered (Begining Date and Ending Date). I also want to search by building. The user can select the building then by the dates desired. I know how to do them seperately, but I dont know how to do both.

 

[theprez]

when you use the open report command, use the filter for the dates and building.

DoCmd.OpenReport "Report Name", , ,"ReportDate >= #" & me.begindate & "# AND ReportDate <= #" & me.enddate & "# AND BuildingField = " & me.building & "

 

[outlaw318]

It keeps telling me that there is an error.

 

[theprez]

What's the exact error message?