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
Solved

Cannot join on memo fields

Posted on 2013-12-12
8
410 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
  • 4
  • 4
8 Comments
 
LVL 49

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 49

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 49

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 49

Expert Comment

by:Gustav Brock
ID: 39713736
You are welcome!

/gustav
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

856 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