Comparing those not in history table

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

Guest

I have two access 2003 tables. One is Client and contains name, index#, and
age... The other is HistoryOfWhoClientDated and contains index# of client and
index# of someone they dated. I want to list every client and give a list of
at least 4 people they have NOT dated before ( from HistoryOfWhoClientDated)
and within a specified age group ( i am actually going to have compare 6 more
fields - but if i can figure this part, i can figure the rest). I know i can
use topvalue somehow but i don't know how to go through every client, match 4
that weren't dated before (as recorded in the history table). Any thoughts
on how to accomplish this? sort of feels like it could be done with DAO (but
i can't use that in 2003Access). I've been staring at the walls all weekend
and don't even know how to begin. Any thoughts on how to approach this would
be greatly appreciated.

Thanks in advance....
 
To get all the people who have NOT dated before, use the query wizard and
select the unmatch records to link between the Client and
HistoryOfWhoClientDated.
That will list all the people, now to get only 4 of them, use the TOP

Select Top 4 field1, field2 From ....

Its better to use it after you apply a sort that suit you.
 
Back
Top