Soykan,

What is the purpose and meaning of this table? From your message it seems as if this table is designed on its side. Whenever you see fields being named D1, D2, D3, ... it indicates a violation of the first normal form. Usually that table design can be replaced by one like;

cDate
gDate
sDate
Sequence
DateVal

In 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/02

In 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/02

Now, 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.