Fields in different tables with identical names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Give them two different names?

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

newName: pathlocator
 
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!
 
Back
Top