August 15, 2011, 04:22 PM
jammer[SOLVED] ACROSS COLUMNS when column names have ampersands and spaces
I know you can force columns to display with an ACROSS statement like this:
ACROSS BUSINESS COLUMNS 1 AND 2 AND 3 AND 4 AND 5
If my Acrross column values are as follows:
A&H Excess
A&H Pro Rata
Casualty Excess
Casualty Pro Rata
Esurance
How do I write the across taking into account that my column names have ampersands and spaces
It tried:
ACROSS BUSINESS COLUMNS A&|H Excess AND A|&H Pro Rata AND Casualty Excess AND Casualty Pro Rata AND Esurance
but it get errors
This message has been edited. Last edited by: jammer, August 15, 2011, 06:02 PM
Dan SatchellTry putting single quotes around your column names.
August 15, 2011, 09:34 PM
jammerThanks the SINGLE quotes worked. This was final way to format the across
ACROSS BUSINESS AS '' COLUMNS 'A&|H Excess' AND 'A&|H Pro Rata' AND 'Casualty Excess' AND 'Casualty Pro Rata' AND 'Esurance'