Accumulative data by weekday and weekly

G

Guest

Greetings all,

I have a table (tblProduction) that stores date of production, actual
production, and production goal for that week.

ProductionDate | DailyProduction | WeeklyGoal
01/01/06 | 9956 | 70000
01/02/06 | 10001 | 70000
01/03/06 | 9591 | 70000
..
..
..
01/08/06 | 9562 | 72500
01/09/06 | 10052 | 72500
01/10/06 | 9986 | 72500

I would like to design a report and chart to allow a user to enter a date
range and a number 1 – 7 reflecting the weekday and then display the data
accumulative from Sunday to the day selected.

Example: A user enters 01/01/06 – 01/14/06 for the date range and 3 (Tuesday)

W/E Date Total Production % of Production
01/07/06 29548 42.21%
01/14/06 29600 40.83%

I am not certain if this would be accomplished with designing a query or
having the report manipulates the data or both. If I have not explained this
well enough, please advise.
 
D

Duane Hookom

You could set criteria like:

ProductionDate Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd And
WeekDay([ProductionDate]) <= Forms!frmDates!txtWeekDay
 
G

Guest

Thank you, Duane. That is exactly what I was trying to accomplish.

--
M.L. Abram


Duane Hookom said:
You could set criteria like:

ProductionDate Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd And
WeekDay([ProductionDate]) <= Forms!frmDates!txtWeekDay

--
Duane Hookom
MS Access MVP
--

M.L. Abram said:
Greetings all,

I have a table (tblProduction) that stores date of production, actual
production, and production goal for that week.

ProductionDate | DailyProduction | WeeklyGoal
01/01/06 | 9956 | 70000
01/02/06 | 10001 | 70000
01/03/06 | 9591 | 70000
.
.
.
01/08/06 | 9562 | 72500
01/09/06 | 10052 | 72500
01/10/06 | 9986 | 72500

I would like to design a report and chart to allow a user to enter a date
range and a number 1 - 7 reflecting the weekday and then display the data
accumulative from Sunday to the day selected.

Example: A user enters 01/01/06 - 01/14/06 for the date range and 3
(Tuesday)

W/E Date Total Production % of Production
01/07/06 29548 42.21%
01/14/06 29600 40.83%

I am not certain if this would be accomplished with designing a query or
having the report manipulates the data or both. If I have not explained
this
well enough, please advise.
Click to expand...
Click to expand...
 
Top