cDate gDate sDate Sequence DateValIn your table one would see;
cDate gDate sDate D1 D2 D3 ... 1/1/02 2/12/02 3/1/02 1/12/02 1/18/02 1/24/02In the new structure you would see;
cDate gDate sDate Sequence DateVal 1/1/02 2/12/02 3/1/02 1 1/12/02 1/1/02 2/12/02 3/1/02 2 1/18/02 1/1/02 2/12/02 3/1/02 3 1/24/02Now, when you want dates 10 through 20 you can;
SELECT * FROM MyTable WHERE Sequence >= 10 AND Sequence <= 20 ...You can then use a SCAN loop to populate the textboxes on the form.