& in report label

[SLO]

I need a column heading in a report to say G & A. Access doesn't like the &
in the label. Anyway to force it? I've tried a few things with no luck.

 

[fredg]

I need a column heading in a report to say G & A. Access doesn't like the &
in the label. Anyway to force it? I've tried a few things with no luck.

Actually, Access LOVES the & symbol.
It loves it so much it wants you to double up the & symbol in the
label caption. <g>
G && A

 

[RoyVidar]

I need a column heading in a report to say G & A. Access doesn't like the &
in the label. Anyway to force it? I've tried a few things with no luck.

Oh, it likes it OK, but you need to double it up.

To get G & A, you need G && A.

 

[SLO]

Excellent, that worked. I was hoping it would be easy!
After 10+ years using Access I still have a lot to learn.
Thanks alot!