MS Access 2003:  How to change Column name in a Crosstab Query

Posted on 2005-04-11
Last Modified: 2008-02-01

I have a cross tab query that lists all of my user's Operating systems.  The column headings are "Windows XP Professional" and "Windows 2000 Professional".  I would like to shorten the names to "Windows XP" and "Windows 2000".

Is there a way to do this?


Question by:bjennings
    LVL 65

    Expert Comment

    by:Jim Horn
    The only workaround I know of would be to have another field that has "Windows XP" instead of "Windows XP Professional", and make that your column header instead.

    You could do this in the same table as the "Windows XP Professional" field, or as a one-to-many table.

    Hope this helps.
    LVL 39

    Accepted Solution

    prefix the field name with the real name followed by :
    Windows XP: Windows XP Professional

    change the Description property of the field in the query
    right click on the field --> Properties

    change the SQL directly
    [Windows XP Professional] As [Windows XP]

    all these do the same exact thing, it is a matter of which interface you want to use.


    LVL 11

    Expert Comment

    Also keep in mind that this type of functionality is supposed to be added to reports, not to queries.  I bet this could be done using a simple SELECT query and the standard features available in reports.

    Author Comment

    I was able to change the heading in the report properties

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now