R rocklee Registered User. Local time Today, 10:07 Joined May 14, 2009 Messages 36 May 16, 2009 #1 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?
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?
pbaldy Wino Moderator Staff member Local time Today, 10:07 Joined Aug 30, 2003 Messages 36,272 May 16, 2009 #2 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
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
R rocklee Registered User. Local time Today, 10:07 Joined May 14, 2009 Messages 36 May 16, 2009 #3 Thanks Paul! Why can't I do this in design mode?
pbaldy Wino Moderator Staff member Local time Today, 10:07 Joined Aug 30, 2003 Messages 36,272 May 16, 2009 #4 You can; as mentioned, in design view change: FieldName to YourNewTitle: FieldName
S Simon_MT Registered User. Local time Today, 18:07 Joined Feb 26, 2007 Messages 2,176 May 16, 2009 #5 You can alias the column by right clicking the field and then Properties. The same can apply to a Table as well. Simon
You can alias the column by right clicking the field and then Properties. The same can apply to a Table as well. Simon