Field name alias does not stick

[elbyc]

I am using Access 2003. I'm working with two tables and 2 queries:
Table 1: "PM_Time" - standard Access table
Table 2: "Lookup_PM" - Links to a sharepoint list
Query 1: "Lookup_PM query" - combines table 2 with another table
Query 2: "PM_Time_Lookup_PM_Query" - combines Query 1 and table 1

I have a field "Country" in both tables. in the second Query
(PM_Time_Lookup_PM_Query), I've renamed the Country field in
"Lookup_PM Query" as "Location of PM: Lookup_PM query.Country"

This works fine for my reports, as the field shows up as expected, but
in the query (and when I export to an Excel file) the field shows up
as "Country". In other words, the alias doesn't stick and I have two
fields in the datasheet called Country.

Any ideas?

 

[Dirk Goldgar]

I am using Access 2003. I'm working with two tables and 2 queries:
Table 1: "PM_Time" - standard Access table
Table 2: "Lookup_PM" - Links to a sharepoint list
Query 1: "Lookup_PM query" - combines table 2 with another table
Query 2: "PM_Time_Lookup_PM_Query" - combines Query 1 and table 1

I have a field "Country" in both tables. in the second Query
(PM_Time_Lookup_PM_Query), I've renamed the Country field in
"Lookup_PM Query" as "Location of PM: Lookup_PM query.Country"

This works fine for my reports, as the field shows up as expected, but
in the query (and when I export to an Excel file) the field shows up
as "Country". In other words, the alias doesn't stick and I have two
fields in the datasheet called Country.

Any ideas?

In query designb view, open the property sheet for the field (in the field
grid) and set its Caption property. That ought to take care of the column
title in the datasheet. I don't know if that will fix whatever's going on
in your export or not, as I would expect the renaming of the field to have
taken effect there already.

 

[elbyc]

That did it - Thank you! That's been bugging me forever.