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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 t
Excel = no problem). BUT, this is what the Client wants to se

Sunday Date
4/11/04................7
4/18/04................7
4/25/04................7
5/2/04..................7
5/9/04..................7
5/16/04................7
5/23/04................8

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

Is there another way to do it

TIA - Bob
 
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
 
Back
Top