I have one table tblRates which field names are 1,2,3.....110.
First record is like Codes , USD, BHD, DKR, ....... TRY, CZK and so on
I want to convert first record to tblRates field name by writing record set
because everytime listing will change. Pls help me how i will convert 1st
Record to Field name. Codes (tex)t and rest other fields data type is Number
and field size is double.
Thanks

Access is a database and should not be thought of in the same manner as Excel
or a spreadsheet. It is not possible to have the first record contain any
specific values as the order in which the records are returned by the
DBEngine can vary. Also, the field names should be representational of the
values contained therein. Such as txtShowName, txtLastname, etc. (You
wouldn't name you kids 1, 2, 3, etc.)

What are you trying to accomplish?

"Wahab" wrote:

> I have one table tblRates which field names are 1,2,3.....110.
> First record is like Codes , USD, BHD, DKR, ....... TRY, CZK and so on
> I want to convert first record to tblRates field name by writing record set
> because everytime listing will change. Pls help me how i will convert 1st
> Record to Field name. Codes (tex)t and rest other fields data type is Number
> and field size is double.
> Thanks
>
>