G
Guest
I have a crosstab query that uses as a row heading a text field that can be
up to 255 characters. The field is only used for holding a comment (it is
set as TEXT) but it is completely screwing up my query. If a particular
record has an entry in this field that is over 202 characters then the
columns of the crosstab for that record show up blank. If the field is 202
characters or less then the crosstab columns show correctly. Has anyone ever
experienced this? Or any idea why it happens? It seems strange that the
number of significant characters would be 202. Thanks for any insight.
Jeff
up to 255 characters. The field is only used for holding a comment (it is
set as TEXT) but it is completely screwing up my query. If a particular
record has an entry in this field that is over 202 characters then the
columns of the crosstab for that record show up blank. If the field is 202
characters or less then the crosstab columns show correctly. Has anyone ever
experienced this? Or any idea why it happens? It seems strange that the
number of significant characters would be 202. Thanks for any insight.
Jeff