matching up simillar records

  • Thread starter Thread starter turtlewick
  • Start date Start date
T

turtlewick

please help

I have 2 tables one with client id, address id and address info, the
other table has name, ph# etc plus a the adrress id and client id. I
thought this would make it easier to send only one mailing to an
address even there is more than one person living there. So every
client married or not has their own record with a unique client id.
The address table has a unique code for ea different address. So when
the client id and the address id are the same I want to print a label
looking like:

Tom Jones
Tine Jones
123 Lake dr
canton, ga 30188

I have looked everywhere I know and Im so confused I cant think
straight. anyone? please?
anitra
 
Okay wait will "like" work here? I mean will it only pull exact same?
if I dont use *
off to try it
 
Okay I want to "do" something when they match like print the name new
line next name then the address under that but where do I build the
expression?
does like work with a parameter like then do?
 
Back
Top