How to cumulate data in ms access db table between two dates using VBA in Ms Excel?

Hi,

I am working on a vba app based in ms excel. I write and query data from an ms access db via forms in ms excel.

I am now trying to dynamically populate a OWC Graph based on queried data. For me to achieve the type of graph i want, i need my data to be cumulated in a way that not only does a query show data for when it was last updated but also for when it was not.

For example if data between 01/01/08 and 10/01/08 was only updated once on the 05/01/08, therefore my query should look like this:

Date                       Value
01/01/08                 1              (Stored in Table)  (original Value)
02/01/08                 1              (Not in table)
03/01/08                 1              (Not in table)
04/01/08                 1              (Not in table)
05/01/08                 2              (Stored in Table)  (Updated by user)
06/01/08                 2              (Not in table)
07/01/08                 2              (Not in table)
08/01/08                 2              (Not in table)
09/01/08                 2              (Not in table)
10/01/08                 2              (Not in table)

Now i understand that it is hard to get a query to do the above based on start and end dates and hence i am having to write to a temporary table for graphing purposes.

I am now stuck where i need to calculate the number of days between the new update and last update in order to enter all  missing records. It even gets more complicated if the date range falls between two months hence i would have to know if the original month had 30 days or 31 days?

Please assist me in determing how i can increment the dates and insert into the table based on start and end dates plus data retrieved from query so that i can get a complete set of data which can then be used to plot a graph.

Many thanks,

Nav