COMPARE 2 TABLES, EXTRACT LINES WHERE THEY MATCH

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top