Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 4
  • 4
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Regards,
Seamus
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now