Column Names Not correct 1

[quig699]

I have a query that I have three tables joined. The join properties are all set to only include rows where the joined fields from both tables are equal. The tables are erors, employee list and supervisor. Most of the query columns are from the Errors table. Then I have a "supervisor" column from Employee List and columns "divisiion" and "location" from Supervisor table. My problem is that when I run the query the "division" column is listed as Supervisor.Division and I have no idea why it is renaming it. The other column "location" from the same table shows up fine. I have used this type of joining in a query previously and have not had this happen. Any thoughts??

Thanks so much!!
Amy

 

[SkipVought]

Hi,

TableName.ColumnName is standard notation.

Could it be that the Division column appears in more than one of your three tables AND it is not in the join?

Skip,

_[red][/red]

 

[quig699]

You are correct. I have another column named Division based on one of the other tables in my query. Thank you so much!!! You have saved my sanity!!!

AMY