Change field Names with first record

W

Wahab

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
 
D

dch3

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?
 
L

Linq Adams via AccessMonster.com

It would appear that the OP is trying to "commit spreadsheet upon a database!
" as John Vinson says! And if

"field names are 1,2,3.....110"

indicates 110 fields in a single table, the design here is most likely
seriously flawed. More than 25-30 fields in a single table is generally
considered to be a sign of a lack of normalization.I'll repeat dch3's
question "What are you trying to accomplish here?"
 
Top