H
Howard
I have a crosstab query that returns an unknown number of columns with
unknown headers.
I have a simple make table query that in essence says this (not the real
names)
SELECT * INTO NewTable FROM MyCrossTab;
My problem is that before making the table I want to extract just the
first character of any data longer than one character so that all data
in the new table is only one character long.
I can't see how I can transform the data when I don't know what it is
called or what column its in
Any ideas?
Howard
unknown headers.
I have a simple make table query that in essence says this (not the real
names)
SELECT * INTO NewTable FROM MyCrossTab;
My problem is that before making the table I want to extract just the
first character of any data longer than one character so that all data
in the new table is only one character long.
I can't see how I can transform the data when I don't know what it is
called or what column its in
Any ideas?
Howard