"Fill-in data when there's no data"

Hi Bob,

I have helped several people do similar;
it is for sure doable and fairly straightforward....
but I would first like to know how you
will be limiting the dates, i.e., I assume you
don't want to chart all the data.

Could you reply with an initial Select query
that you would use for the chart if the client
did not want to "fill-in" data?

Thanks,

Gary Walter


"Bob Barnes" wrote
I have a client who wants to "fill-in data when there's no data".

IE. A reading of 75 is taken on 4/7/04 (a Wednesday).
The next reading isn't until 5/21/04 (a Friday) & is an 82.

The client wants to see a Chart (I'll automate the Access data to
Excel = no problem). BUT, this is what the Client wants to see

Sunday Dates
4/11/04................75
4/18/04................75
4/25/04................75
5/2/04..................75
5/9/04..................75
5/16/04................75
5/23/04................82

I'm sure I can write code to fill an existing Table (just delete
everything in the Table prior to re-populating it).

Is there another way to do it?

TIA - Bob