Results 1 to 2 of 2
  1. #1
    djclntn is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    476

    CrossTab Query Question


    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?”

  2. #2
    djclntn is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    476
    Nevermind, now it's suddenly showing the "mmm" in the column headers

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Crosstab Query
    By BLD21 in forum Queries
    Replies: 2
    Last Post: 09-12-2011, 11:58 AM
  2. Crosstab Query Question
    By hnguyen1987 in forum Access
    Replies: 1
    Last Post: 08-20-2010, 12:54 PM
  3. Crosstab Query
    By lukewarmbeer in forum Access
    Replies: 2
    Last Post: 08-13-2010, 05:10 AM
  4. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  5. Query - Crosstab ?
    By rob4465 in forum Access
    Replies: 1
    Last Post: 01-28-2010, 08:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums