Query for retrieving week end date.

I

iholder

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

Martin Fishlock

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.
 
I

iholder

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.
 
B

babyatx13 via AccessMonster.com

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
 
Top