Type Mismatch

[lars7]

Hi there,
Can anyone see why I'm getting a "type Mismatch" in my Query.

strsql = "SELECT tbltruststaff.trust, tbltruststaff.DIV, tbltruststaff.DISCIPLINE, tbltruststaff.PAYNO, [surname] & ',' & [forename] AS Employee, tbltruststaff.LOCATION, tbltruststaff.GRADE, [jdCodeno] & IIf(IsNull([jdadditno]),""," / " & [jdadditno]) AS CODE, tbltruststaff.FWDFORMATCH AS Weekending FROM tbltruststaff "

 

[lespaul]

what is the field type of [jdadditno]? string? number?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[lars7]

Hi Lespaul,
[jdadditno] is a number field.

 

[lars7]

Hi Again,
Yes your right it's that one thats causing the problem, I removed it and it worked ok. Is there an other way of doing that.