Type mismatch between Access and SQL

[Halliarse]

Access 2010
SQL 2008 R2

I have an access query where I have linked an Access table, tblJobs, with a SQL table, dbo.SL_Transactions using fields OrderNo and ST_Order_Number, which have formats of Text and Float respectively.

When I run the query I get a 'Type mismatch in expression' error.

Can anyone advise how to get around this?

Thanks

Steve

 

[lameid]

What is the SQL of the query you are trying to run?

 

[Halliarse]

Hi Lameid

Thanks for responding, however, I have managed to resolve this myself by including the SQL table, not linking it and using a CSTr within the criteria of the field that I want to link against.

Kind regards

Steve