Trailing spaces in Pivot tables

[Fred]

Does anyone know why 'abc' and 'abc ' appear as two different values in
pivot table page, row, or column fields? Is there a configuration setting to
control this? The same values appear only once in the filter list in a
filtered data table, and behave per ANSI 92 (ie 'abc'='abc ') in Microsoft
query group and criteria statements.
thanks in advance
Baffled in Bury

[Tom Ogilvy]

to the best of my knowledge, there isn't. Pivot Tables are not using SQL to
the best of my knowledge. In a cell, your example is false.



--
Regards,
Tom Ogilvy



"Fred" <[email protected]> wrote in message
news:[email protected]...
> Does anyone know why 'abc' and 'abc ' appear as two different values in
> pivot table page, row, or column fields? Is there a configuration setting
to
> control this? The same values appear only once in the filter list in a
> filtered data table, and behave per ANSI 92 (ie 'abc'='abc ') in
Microsoft
> query group and criteria statements.
> thanks in advance
> Baffled in Bury