View Single Post
  #1 (permalink)  
Old July 6th, 2007, 05:06 AM
David Coulter David Coulter is offline
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Between And Specifier

I have a report with multiple subreports. Some subreports require input of one date [Month] and others require input of a date range [IncidentMonth]. I am using a form to enter the date range [FromDate] and [ToDate]. Can someone please help with the VBA code ... what I am using doesn't work.

DoCmd.OpenReport stDocName, acPreview, , "[IncidentMonth] Between Forms![frmRunReport]![FromDate] And Forms![frmRunReport]![ToDate] AND [Month] = Forms![frmRunReport]![FromDate]"

Thanks

Reply With Quote