Fields in different tables with identical names

[simonc]

I am compiling a query with fields from two different tables. Both tables
have a field called "PathLocator" and I need both of these in my query. There
is no difficulty in dragging these fields from the table boxes into different
columns in the query design.

My problem occurs when I use Excel to access the data in the query and copy
it into a spreadsheet. Because the query has two fields with the same name
Excel reports that there is ambiguity in the name PathLocator and won't
extract the data.

How can I modify my Access query to distinguish the two fields so that Excel
knows which data to extract?

Grateful for any help

 

[scubadiver]

Give them two different names?

Before the field name insert a new name and then a semi-colon like

newName: pathlocator

 

[simonc]

Many thanks for this - it has resolved my problem. Although it's a very
simple solution it would have taken me hours ploughing through Access Help to
work how to do this!