Help on filling in Calender days

A

Al

I have a query that has "Treatmentdate", "Dose" and "Off" Treatment fields. I
am trying to fill all the missing calender dates. Example:

TreatmentDate Dose Off
-----------------------------------------
1-1-07 300
1-4-07 250
1-5-07 Off
1-9-07 330
What I need to do is to fill the calender dates as follow:

TreatmentDate Dose Off
-----------------------------------------
1-1-07 300
1-2-07 300
1-3-07 300
1-4-07 250
1-5-07 Off
1-6-07 Off
1-7-07 Off
1-8-07 Off
1-9-07 330
And so On. What is the best way to do this?
thanks
Al
 
Top