Bearing in mind I am using VB5:
I have a data set which updates daily and consists of a number of currencies (the number could change but is unlikely to do so). For each currency there is a number of future dates, and a number of values corresponding to the dates.
The problem is that with each update the number of dates and values could change for each currency, the dates themselves will change, and the number of dates and values will not be the same for each currency even on the same update.
If your following this then I'm impressed!
Now, I'm going to be using these figures for historic analysis so I need a good way of storing the data day by day so that it can be easily accessed/referenced in the future.
If anyone can outline a structure for this little lot I would be more than grateful as my brain is now mush!
Thanks in advance