mud2
07-12-2009, 08:50 AM
How do I get the name of a field (in a table) from its ordinal position? The data can be found by:
data = MyrecordSet.Fields(Ordinal Position)
But the name of the field?
A "reverse" is available through the "Fieldnames" property, where one can set the names as a function of the ordianl position...when setting up the table..but this is not what I want!
Thanks.
By the way, nobody has commented on my discovery(?) that a sort Query is inconsistent with a "strcomp(str1,str2,0)" of the sorted table!
data = MyrecordSet.Fields(Ordinal Position)
But the name of the field?
A "reverse" is available through the "Fieldnames" property, where one can set the names as a function of the ordianl position...when setting up the table..but this is not what I want!
Thanks.
By the way, nobody has commented on my discovery(?) that a sort Query is inconsistent with a "strcomp(str1,str2,0)" of the sorted table!