Change field Names with first record

  • Thread starter Thread starter Wahab
  • Start date Start date
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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top