Parameter Issue

F

FA

I would like to know how to setup the Date parameter to see the results
for past week (Last Seven Days) i want to make a command button to view
the report and i dont want user to enter the date. The date is the past
week ( past seven days from today).

On another report i want to set the Date Parameter to see the results
for past 14 days and next 30 days. Meaning the start date should be
past 14 days from today and the end date should be 30 days onward from
today's date.

My Date field name is Test_Stat_date

Can some one help me out please

Thanks
Moe
 
F

fredg

I would like to know how to setup the Date parameter to see the results
for past week (Last Seven Days) i want to make a command button to view
the report and i dont want user to enter the date. The date is the past
week ( past seven days from today).

On another report i want to set the Date Parameter to see the results
for past 14 days and next 30 days. Meaning the start date should be
past 14 days from today and the end date should be 30 days onward from
today's date.

My Date field name is Test_Stat_date

Can some one help me out please

Thanks
Moe
Click to expand...

DoCmd.OpenReport "ReportName", acViewPreview, , "[Test_Stat_date]
Between Date()-7 and Date()"

DoCmd.OpenReport "ReportName", acViewPreview, , "[Test_Stat_date]
Between Date() - 14 and Date() + 30"
 
Top