Type mismatch in expression

[Blackwidow]

I have two really simple tables which both have a field called BP which are both number long integral fields. I simply wanted to create a query that looked at tblBPWithShipToPrimary and linked the BP To the table tblZDEL and then provided me a list of matching BP numbers from TBLZDEL.

Really simple, done it a million times but I am getting a Type mismatch in expression.

I have a only include rows where the joined fields from both tables are equal join to the BP numbers in both tables..

The only field I am showing in the query is BP from table tblZDEL

Any suggestions?

 

[Blackwidow]

Me being stupid!! Forget it it was a stupid mistake on my behalf.. I was looking at the wrong field and had one of them as text not number