J
John
The column heading in a crosstab query results in several fields. In
the table I am querying the data for these fields is all stored in a
text field, but I nead to change this so that some fields are values
and some fields are text. My original table is for example:
ID FieldName DataValue DataType DataLength
1 MyDate 37874 Date
1 MyText Widget Text 255
1 MyQuantity 100 Integer
1 MyCost 20.20 Double
2 MyDate 37874 Date
2 MyText Tiglet Text 255
2 MyQuantity 300 Integer
2 MyCost 25.75 Double
In this table, DataValue is a Text field, in the Crosstab Field Name
is the Column Heading and DataValue is the Value. How can I make
MyQuantity come out of the Crosstab Query as an Integer using the
DataType field in the table ?
I will have a large number of fields listed under FieldName.
the table I am querying the data for these fields is all stored in a
text field, but I nead to change this so that some fields are values
and some fields are text. My original table is for example:
ID FieldName DataValue DataType DataLength
1 MyDate 37874 Date
1 MyText Widget Text 255
1 MyQuantity 100 Integer
1 MyCost 20.20 Double
2 MyDate 37874 Date
2 MyText Tiglet Text 255
2 MyQuantity 300 Integer
2 MyCost 25.75 Double
In this table, DataValue is a Text field, in the Crosstab Field Name
is the Column Heading and DataValue is the Value. How can I make
MyQuantity come out of the Crosstab Query as an Integer using the
DataType field in the table ?
I will have a large number of fields listed under FieldName.