Find unmatched values between Memo field and Short Text field (1 Viewer)

[MilaK]

Hello,

I have a linked table from SQL server with a “Memo” field that I need to link to a local Access table where the corresponding field is “short text”. The goal is to find unmatched values between the two fields. I’ve tried the unmatched query wizard but it does not let me link a memo field. Is there a trick that will allow me to find unmatched records between the two?
Here is the unmatched values query that I’ve tried:

I was able to connect the tables but don't know how to return the values that are unmatched.

SELECT qry_A_locus.*, qry_All_As.*
FROM qry_A_locus, qry_All_As
WHERE (((qry_A_locus.SingleAgSpecificity)=[qry_All_As].[A]));


Thanks

 

[Ranman256]

last i heard,you cannot perform action on memo fields in a query.
(perform a function on them)
you can only bring them forth in a query.

has this changed? anyone?

 

[MilaK]

What do you suggest I do? populate two listboxes with the values and filter one listbox with another?

 

[JHB]

Create a query in which you shorted the memo field to 255 characters, Left(TheMemoField,255).
Then use that query in the unmatch query.

 

[isladogs]

Create a query in which you shorted the memo field to 255 characters, Left(TheMemoField,255).
Then use that query in the unmatch query.

That will catch most if not all of the differences.
However it won't pick up any where otherwise identical but the memo field then has additional characters.

To do that do a second query comparing lengths or just selecting those where Len(MemoField)>255.
Combine the 2 queries using a UNION