Make Table query with crosstab as its source?

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
 
Top