Query for retrieving week end date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to design a week end report. The weekly report includes days from
Monday to Friday. Week ending on Friday.
 
Hi:

I find it better to firstly write a query to get the data together join any
tables etc.

You can then use the query to feed into the report.

But without any details of your tables it is a little difficult to advise.
 
The primary fields of the query would be [DailyDate], [MailType] and
[MailCount]. The mail count for the week.

Example; Start Date of the week -Monday and End Date of the week -Friday.
Allowing the user to input only the end of the week date. The query to
calculate the start date.
 
iholder said:
I need to design a week end report. The weekly report includes days from
Monday to Friday. Week ending on Friday.
Click to expand...

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
 
Back
Top