Make records in a table using VB (for a graph)

[Jeff E via AccessMonster.com]

I have a graph based on a table. The table has parts, count of parts
returned for month, date (in mmmm yyyy format). If no parts were returned in
a given month, the graph simply skips over it. That is to say it doesn't
show it as a zero month. What I want to do is write something that looks at
the min and max date, the dates already in the table, then inserts the dates
needed (with a zero count). Simple right?

 

[Tim Ferguson]

What I want to do is write something that looks at
the min and max date, the dates already in the table, then inserts the
dates needed (with a zero count). Simple right?

Excel does this by default...


Tim F