How do I change the title of a column in a datasheet?

[Guest]

I'm trying to create a query that uses the same table to name two different
fields, and I don't want the second occurrence of that element to show up as
'Expr1004'.

Specifically, I'm using the same table to supply the title of the 'referred
by' team and the 'referred to' team. The second occurrence shows up as
'Expr1004' and I can't seem to change that in a way that sticks.

Any thoughts?

TIA...

 

[Guest]

Hi

In the query design view the field in question will have something like...

Expr1004: table.column

Change the Expr1004 to whatever you want (leave the colon as it is)

Or you can change it in SQL view where the field will occur in the SELECT
statement something like...

table.column AS Expr1004

hth

Andy Hull

 

[John Spencer]

Open the query in design view
Find the column that has
Field: Expr1004: [SomeFieldReference]

Replace Expr1004 with ReferredTo or ReferredBy depending on your need.

In the SQL
SELECT SomeTable.SomeField as Expr1004 ...

would be changed to
SELECT SomeTable.SomeField as ReferredBy ...

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..