Compare those not in history table

  • Thread starter Bill Brinkworth
  • Start date
B

Bill Brinkworth

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....
 
T

tina

don't multi-post please. it wastes the time of folks who may answer your
question in one newsgroup, when it has already been answered in another. if
you feel you *must* post to more than one newsgroup (rarely necessary), then
please cross-post - that is, include both newsgroup addresses in one
message, rather than creating a separate message for each newsgroup.

the tablesdesign newsgroup is probably not appropriate (unless it is
determined that your table design is flawed). the queries newsgroup would
probably have been more on-target.

hth
 
T

tina

tina said:
don't multi-post please. it wastes the time of folks who may answer your
question in one newsgroup, when it has already been answered in another. if
you feel you *must* post to more than one newsgroup (rarely necessary), then
please cross-post - that is, include both newsgroup addresses in one
message, rather than creating a separate message for each newsgroup.

the tablesdesign newsgroup is probably not appropriate (unless it is
determined that your table design is flawed). the queries newsgroup would
probably have been more on-target.

hth
Click to expand...

ah, i see that you multi-posted to the queries newsgroup, as well. at least
you're on the right track as to the appropriate group. :)
 
Top