[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2005-04-11
Medium Priority
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 66

Expert Comment

by:Jim Horn
ID: 13753510
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

stevbe earned 600 total points
ID: 13753520
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

ID: 13807462
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

ID: 13809957
I was able to change the heading in the report properties

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

873 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