Failed attempt at concetenation

[snowboarder234]

The help menu was not helpful. What does this mean and how can I fix it?

[Kirsti]

You have a field [LastName] in both tblAdvisor and tblStudent. I know that you have specified tblAdvisor in the 'Table' row of the query, but Access likes you to specify it in your 'Field' row for some reason. Try:

Exper1: ([tblAdvisor.FirstName]) & " " & ([tblAdvisor.LastName])

[snowboarder234]

You have a field [LastName] in both tblAdvisor and tblStudent. I know that you have specified tblAdvisor in the 'Table' row of the query, but Access likes you to specify it in your 'Field' row for some reason. Try:

Exper1: ([tblAdvisor.FirstName]) & " " & ([tblAdvisor.LastName])

Thanks for your help.