Cannot join on memo fields

Hi,

I have an access DB and i am trying to join on memo fields, and i get the error "cannot join on memo fields"

Is there a workaround for this?

Access 2010

Many thanks
Seamus2626Asked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
Yes. Look at the Left syntax:

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)

/gustav
0
 
Gustav BrockCIOCommented:
Try using no join and use where instead:

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

/gustav
0
 
Seamus2626Author Commented:
Havent used Access in a while, where do i put this line, in the criteria box?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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

"you have entered an operand without an operator"

thanks
0
 
Gustav BrockCIOCommented:
It's SQL. Use the SQL view:

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

/gustav
0
 
Seamus2626Author Commented:
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
0
 
Seamus2626Author Commented:
Perfect, thanks for your patience gustav.

Regards,
Seamus
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.