If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
Thread Tools | |
Display Modes | |
|
|