bplus - I agree combining the date fields to one YYYY-MM-DD field, stored as String, and info retrieved using Mid$ is an approach which I did consider but as I recall, there was a lot of coding for those times when I had only the month and event, or only the year and event, and sometimes just the event with lots of work to track down more specifics on the event. So I had to have the date field as only YYYY, or only MM, or only DD and the Event. Combining the date fields worked once I had all the data for a complete record. Also, the data in this array was used in calculations and stats, so it had to be converted from strings to numeric. I think I ran into some issues on the reliability of the numeric values which is why I settled on the date fields as numeric values at the outset rather than strings.
Steve - not exactly sure how the sortable index would work. The stat info needed would be say - how many times did event 3 occur on a Wednesday - or how often did event 6 and event 11 occur together in 2009. I see where the Updating would be a breeze, just add every thing to the last record and keep the array completely sequential. I was trying to find a logical place within the array to squeeze in the new data (thus the thought on Random access to the array), which made the calculations/stats more accurate if the data came to the formulas sequentially.
I did give up on that mighty array a number of years ago and only recently was trying to re-think it using some of the new, very rich QB64 syntax. I was looking at Redim _Preserve and it appears this works by making a copy of the entire array? I don't think it would say copy just a portion of an array? In the case of a my mighty array, if I wanted to make an update to say Feb 15, 2002, I could preserve all the data from the beginning of the array up to Feb 15, 2002 in one group, all the info in the array from Feb 16, 2002 in the next group - then write back the 1st group, then write my new entry for Feb 15, 2002 and then added the second group back? Redim _Preserve does all or nothing I gather???