How to change column titles on queries

rocklee

Registered User.
Local time
Today, 10:07
Joined
May 14, 2009
Messages
36
I have a query that looks up a table and also makes count from another table. I'd like to change the field title from "countofxxxx." to something more user friendly, how do I do this?
 
If you look at the query in SQL view, you will see:

...Count(FieldName) AS CountOfFieldName...

You can change it there. In design view, you can add this before the field name:

YourNewTitle: FieldName
 
Thanks Paul!

Why can't I do this in design mode?
 
You can; as mentioned, in design view change:

FieldName

to

YourNewTitle: FieldName
 
You can alias the column by right clicking the field and then Properties. The same can apply to a Table as well.

Simon
 

Users who are viewing this thread

Back
Top Bottom