Need to calculate a weekday's date given two dates

[KEKeogh]

Ok, I have no clue if this is even possible.

I'm creating an Access 2000 report to use to print timesheets for employees to fill out. I have a table with the pay periods and a table withe employee names.

The report I currently have has that basic information but want I need to add is the date of each weekday with the time period being reported.

For example: If the pay period is 8/7/2011 through 8/13/2011, I need a text box for Tuesday saying the date is 8/9/2011.

And so forth for each day of the week.


Sometimes a time period may not even have a certain day of the week which should come up blank. Like the next period is 8/1/2011 through 8/6/2011, with no Sunday in that period.

I know that sounds really confusing and I will gladly give more info for any help someone can give.

The old excel macro they've been using is a pain the neck when it comes to adding and deleting employees.

Thanks for any help.
Kathie

 

[KEKeogh]

I figured out a method in playing around.

I put in the query a count of the number of the specific days in the period (like there is 1 Monday but no Sundays in the period 8/1/11 through 8/6/11).

Then I used if statements for each day of the week to calculate the date.

Probably a simpler way but this works.

Thanks anyway.
Kathie