Getting an Runtime error 13 when defining a recordset, have I got the syntax wrong ?

  • Thread starter Thread starter acs68
  • Start date Start date
A

acs68

Hi all,

I created a query using the Access Query Builder and pasted it into the
db.openrecordset as can be seen below. It doesn't seem to want to work and I
am getting a Run-time error '13': Type Mismatch. Any ideas as to what I am
doing wrong.

Set TextRS = db.openrecordset("SELECT RMTRANFUND.*, RMFUND.FUNDNAME FROM
RMTRANFUND LEFT JOIN RMFUND ON RMTRANFUND.FUND = RMFUND.FUND WHERE
(((RMTRANFUND.TRANKY)=269347));")

cheers,

Adam
 
Back
Top