compering 2 fields from 2 different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

i am trying to compare USDAMT FROM MY FUNDING TABLE WITH FUNDING AMT FROM MY
ACTIVITY TABLE I TRIED EVERYTHING UNMACHED QUERY, SELECT STATEMENT, <>, IS
NULL but it doesnt show correct info.

i have usd amt and funding as common field and transaction no. as common
field but they are not in a sorted order it can be like 1, 2, 3, 5, 4 ,
8,6.......

so i want it to show me only records that do not match
 
Hi Karl,


can you show me how to do it cause i am new to access and trying to learn it
thru different medium.
thanks
 
Back
Top