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.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])