Cannot join on memo fields

Try using no join and use where instead:

   Where Left(tblOne.Memofield1, 255) = Left(tblTwo.Memofield2, 255)

/gustav

Havent used Access in a while, where do i put this line, in the criteria box?

When i do put it ib the criteria field, i get the msg

"you have entered an operand without an operator"

thanks

It's SQL. Use the SQL view:

Select tblOne.*, tblTwo.*
From tblOne, tblTwo
Where Left(tblOne.Memofield1, 255) = Left(tblTwo.Memofield2, 255)

/gustav

Select INPUT D2 DATA.*, Calculation D2.*
From INPUT D2 DATA, Calcualtion D2

Where Left([INPUT D2 DATA].[Customer Type], 255) = Left([Calculation D2].[Client Type], 255)


Im getting a syntax error pointing at the second line and highlighting DATA

Many thanks

Perfect, thanks for your patience gustav.

Regards,
Seamus

You are welcome!

/gustav