If I have this query:
- Mnth: Format([TDATE], “mmm”)
- ArtistID
- SumOfWKDAY
- SumOfDuration
- SumOfBllng
When I create/run a CrossTab query my column headers are the Mnth, but are shown in numbers instead of “mmm.” How can I get my Mnths to display in “mmm?”