COMPARE 2 TABLES, EXTRACT LINES WHERE THEY MATCH

D

dcozzi

I have a spread sheet a few thousand lines of "buys" and another of "sells"

I need to be able to find trades were 4 fields are the same. The way i
currently do it is excel, compbine the 2 lists, and use a formula such as
=if(A2=A1,"Y","N") in a column all the way down. Im not sure how to reference
cells above a cell in the same filed in access.

Ex.

BUY SELL

PORTFOLIO TICKER PORTFOLIO
TICKER
11111 ABC 22222
XYZ
33333 DEF 33333
DEF
44444 GHI 55555
JKL

QUERY RESULTS

PORTFOLIO TICKER
33333 DEF
 
G

Gareth

Import your buys into table 1, your sells into table 2 and then create a
select query joining table1.field1 to table2.field1, table1.field2 to
table2.field2 etc.

It will return only the records where all joined fields match.

Regards
 
Top