Convert record names to field names

G

George

Hi,
Is it possible to convert the record names in row 5 to become the field
names for the table?
thanks
George
 
V

Vincent Johns

If I understand the question correctly, you can do that via a Crosstab
Query. If the names are not suitable as field names, you can prefix the
field's value with a suitable string constant. If your goal is to
produce a Table, you can write a Make-Table Query based on the Crosstab
Query.

However, your reference to "row 5" is puzzling. I'm assuming that [row
5] is a field name in your Table. If not, and it refers to just one
record, then what you might need to do is manually copy those names into
Query Design View or Table Design View, or something like that.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
G

George

thanks Vincent - i copied them into a query

Vincent Johns said:
If I understand the question correctly, you can do that via a Crosstab
Query. If the names are not suitable as field names, you can prefix the
field's value with a suitable string constant. If your goal is to
produce a Table, you can write a Make-Table Query based on the Crosstab
Query.

However, your reference to "row 5" is puzzling. I'm assuming that [row
5] is a field name in your Table. If not, and it refers to just one
record, then what you might need to do is manually copy those names into
Query Design View or Table Design View, or something like that.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

Hi,
Is it possible to convert the record names in row 5 to become the field
names for the table?
thanks
George
Click to expand...
Click to expand...
 
Top