iholder said:
I need to design a week end report. The weekly report includes days from
Monday to Friday. Week ending on Friday.
If you use a form to enter your end date in the query, you can use a table
with Date1 & Date2, Date 1 = Monday, Date2 = Friday put both in a form make
only Date2 visible.
In Date2 properties After Update [Event Procedure] in VBA write Date1 = Date2
– 4
You can use the Northwind Sample Access Project, Sales By Year report as an
example; you’ll find it under Help, Sample Databases.
This is only one suggestion, I’m sure there are other ways to do this.
K Board