Search for dates

[Guest]

I have a table with a startdate and an enddate.
ex. 04/30/04, 04/30/05
I have a form that opens a report with a where statement
DoCmd.OpenReport stDocName, acPreview, , ["startDate] between #" &
Me.DTPicker1 & "# And #" & Me.ActiveXCtl2 & "#"

Is there a way to open the report so I can search on both the startdate and
enddate in the where statement.

 

[Al Camp]

Jerry,
If I understand correctly... in aircode...
Where (StartDate Between Date1 AND Date2) AND (EndDate Between Date1
AND Date2)
hth
Al Camp

 

[Guest]

Al, I had to use or instead of and but it works great.
Thank you
--
jerry

Jerry,
If I understand correctly... in aircode...
Where (StartDate Between Date1 AND Date2) AND (EndDate Between Date1
AND Date2)
hth
Al Camp

I have a table with a startdate and an enddate.
ex. 04/30/04, 04/30/05
I have a form that opens a report with a where statement
DoCmd.OpenReport stDocName, acPreview, , ["startDate] between #" &
Me.DTPicker1 & "# And #" & Me.ActiveXCtl2 & "#"

Is there a way to open the report so I can search on both the startdate
and
enddate in the where statement.