Solved

Cannot join on memo fields

Posted on 2013-12-12
8
412 Views
Last Modified: 2013-12-12
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
0
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39713699
Try using no join and use where instead:

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

/gustav
0
 

Author Comment

by:Seamus2626
ID: 39713710
Havent used Access in a while, where do i put this line, in the criteria box?
0
 

Author Comment

by:Seamus2626
ID: 39713716
When i do put it ib the criteria field, i get the msg

"you have entered an operand without an operator"

thanks
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39713718
It's SQL. Use the SQL view:

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

/gustav
0
 

Author Comment

by:Seamus2626
ID: 39713722
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
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39713724
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
 

Author Closing Comment

by:Seamus2626
ID: 39713729
Perfect, thanks for your patience gustav.

Regards,
Seamus
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39713736
You are welcome!

/gustav
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Undo Button 1 34
default value of combobox 25 40
Linking Master Child Fields 2 26
access to sql migration 5 24
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question