Print report and up date each time

[oxicottin]

Hello I have a report that needs to print twice but on the report I have a text box that needs to change its date +1 on each print. The starting date is on a form and I need to start on a Monday from that date which is -4 and Tuesday is -3

Forms!frm_WeeklySafetyHuddle.txtWeekEnding - 4
and the second date is
Forms!frm_WeeklySafetyHuddle.txtWeekEnding -3

Hope this makes sense..

 

[arnelgp]

i added a function, WeekFirstDay to get the Starting Monday/Tuesday of a date (date in Form1).
then i added table zForMonTueReport, that will be used in Query (Query1) to return the two dates.
next i made report, report1 to show the two dates (group by theDate and will page each group on separate page).
see form1.

 

[oxicottin]

@arnelgp could I just use Open arguments like?

DoCmd.OpenReport "rpt_SpotCheck", acViewPreview, , "WeekEnding = " & Me.txtSpotcheckDate - 4
DoCmd.OpenReport "rpt_SpotCheck", acViewPreview, , "WeekEnding = " & Me.txtSpotcheckDate - 3

The txtSpotcheckDate is the date field and WeekEnding is the control source of the textbox.