Select From Inner Join - advice needed

[werafa]

Hi all,

I had this working - and now it is broke.
can anyone advise whether my SQL syntax is wrong or whether I need to look elsewhere?



sSQL = "SELECT Organisations.OrgCode " & _
"FROM Staff INNER JOIN Organisations " & _
"ON Staff.Org = Organisations.Id " & _
"WHERE Staff.cName = '" & myPerson & "'"

My Organisations table has fields:

ID (PK)
OrgName
OrgCode


My Staff Table has fields that include:

ID (PK)
cName (calculated Field)
Org (linked to Organisations.ID)


myPerson is a string variable that should = cName for one record

Thanks
Werafa

[werafa]

found it - was data type mismatch on the join