Match memo fields

R

RSunday

I have two tables with a memo field.

I want to find all records where this memo filed is the same in the two
tables - but I can't join two memo fields in the query.

Is there a trick to do that?

Alternatively I would have to write a routine that compares the two fields
and flags the ones that match.
 
C

Chaim

Select * from tblM1, tblM2 where [tblM1].[memo1] = [tblM2].[memo2]

For QEB Grid, given two tables, tblM1 (consisting of memo1 (type = memo))
and tblM2 (consisting of memo2 (type = memo)):

Field: memo1 memo2
Table: tblM1 tblM2
Criteria: [memo2]
 
J

John Spencer (MVP)

UNTESTED IDEA

SELECT *
FROM TABLEA, TABLEB
WHERE TableA.Memo = TableB.Memo

In the grid
Add Both Tables to the grid with no join
Select the fields you want to display.

In one of the columns:
Field: MemoField
Table: TableA
Criteria: = [TableB].[MemoField]

This will probably not be an updatable query. If you need that, then post back.
 
Top