D
David Cox
I do not have a computer running Access at the moment. An idea occurred to
me.
a common task is to convert table data such as:
Key col1 col2 col3 ...... colN
to a new table
Key colkey
The usual responses I have seen is VBA or a big union query
Is it possible to create a table with just one numeric field colkey
containing records with values 1 to N, put that in the design grid with the
original table in a make table query with output fields Key and colddata,
and write:
coldata: IIF(colkey=1,[col1],IIF(colkey=2, [col2],(IIF(colkey=3,[col3]
..........
Apologies if I am wasting group time.
Comments?
David F. Cox
me.
a common task is to convert table data such as:
Key col1 col2 col3 ...... colN
to a new table
Key colkey
The usual responses I have seen is VBA or a big union query
Is it possible to create a table with just one numeric field colkey
containing records with values 1 to N, put that in the design grid with the
original table in a make table query with output fields Key and colddata,
and write:
coldata: IIF(colkey=1,[col1],IIF(colkey=2, [col2],(IIF(colkey=3,[col3]
..........
Apologies if I am wasting group time.
Comments?
David F. Cox