Filter StartingDate and EndingDate in ubreport

[Hanson]

I have used an Allen Browne's tips for Microsoft Access: "Limiting a Report
to a Date Range" in a report. It worked well in main-report but did not work
in 2 subreports.
Anyone can help please.
....
Thanks
Hanson

 

[Allen Browne]

I think you are referring to this article:
http://allenbrowne.com/casu-08.html

If so, it explains 2 possible approaches. Method 2 (the WhereCondition of
OpenReport) is suitable for the main report. For subreports, use Method 1
(the parameter query that reads the limiting dates from the form).

Access calls the subreport multiple times, typically once for each record in
the main report. Each time it is called, the subreport will read the values
from the text boxes on the form (provided you leave the form open in the
background.)

 

[Hanson]

Thank you so much, Allen
I really appreciate your help.