address question

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

turtlewick

Okay I have a table with just addresses and a idaddy unique to each
record. I have another table with name and other personal info and a
client id that is the same for anyone living at the same address.
What command do I use to find when idaddy is equal in these two records
therefore print one name then the other and then the address. I have
looked and looked and my brain is fried.....
 
Okay I have a table with just addresses and a idaddy unique to each
record. I have another table with name and other personal info and a
client id that is the same for anyone living at the same address.
What command do I use to find when idaddy is equal in these two records
therefore print one name then the other and then the address. I have
looked and looked and my brain is fried.....
Click to expand...

As stated there is no way to do this.

You have an IdAddy and an Address in one table, and no corresponding
field in the other, so far as I can tell!

Could you post some more details - fieldnames and datatypes - for the
two tables?

John W. Vinson[MVP]
 
Back
Top