display week dates between to different dates

[Karen0927]

Hello! I have a database where I track and report locations for equipment
and paperwork received (reports that are completed by employees daily)
weekly. The dates for the paperwork are grouped into week ending dates (I
used the function DateOfSpecificWeekDay = DateAdd("d", -DatePart("w",
OriginalDate, 6, 1) + intWeekDay, OriginalDate) the weeks are Friday -
Thursday). The problem I'm having is the dates for the equipment location do
not change every week. So, when I use the DateOfSpecificWeekDay function, it
only gives the weekending date for that date, not the dates that the equpment
is on a particular location. Here's a sample what my imput for paperwork
looks like:

ID Date Foreman Amount
2 5/8/2006 0151 1
306 4/21/2006 0151 1
356 4/25/2006 0151 1
407 4/28/2006 0151 1
444 4/24/2006 0151 1
483 5/3/2006 7451 1
492 5/5/2006 7451 1
2581 4/26/2006 0151 1

This is how I report it:

Foreman 1/2/2006 1/9/2006 1/16/2006 1/23/2006 1/30/2006
0187 5 5 4 5 5
10108 3 5 5 5 5

The table for the equipment history looks like this:

FleetNumber ReqDate ReqNumber ReqShort Job
AB0301 1/30/2006 1472 Assigned - Issue 1900
AB0301 4/1/2006 6306 Unassigned - Return 1900
AB0301 4/1/2006 6542 Assigned - Issue 1001
AB0302 2/4/2006 1689 Assigned - Issue 99998
AB0302 4/8/2006 6695 Unassigned - Return 99998
AB0307 2/4/2006 1553 Assigned - Issue 9045
AB0307 2/18/2006 2929 Unassigned - Return 9045
AB0307 2/18/2006 2936 Assigned - Issue 9995
AB0307 2/25/2006 2969 Unassigned - Return 9995
AB0307 2/25/2006 2982 Assigned - Issue 9045

All equpment is issued, then returned. I need to find the weekend dates
between the 2. Help! Any ideas? I hope I gave info info... lol