Multiplying records

Z

zzerek

I am working on a Labor projection database. I need to be able to
create a record for every day (only for workingdays) between start and
end dates. For example, Job will start on 4/5/2007 and will be
completed on 5/15/2007. I need to create a table with every working
day in between start and end dates. I also need to create other
fields in that table.

table should display records as shown below:

4/5/2007 10 Actual Acme
4/6/2007 15 Projection Merlin
4/9/2007 21 Actual Harry
..
..
..
5/15/2007 10 Actual Star
 
Top