trying to join information from a table with info from a query???

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

Guest

I have a query of paid members but thier phone numbers are in a table - how
can I get that information together?

Thank you thank you!!!!
 
Without knowledge of the table structures or SQL, it's not possible to
specify, but the answer is probably link them together in another query.
 
I have a query of paid members but thier phone numbers are in a table - how
can I get that information together?

Thank you thank you!!!!
Click to expand...

By joining the Table to the Query on some suitable field, such as the
unique MemberID. Or, and this is really pretty much equivalent,
including the Phone table in your query, joining it to the Member
table on (again) some suitable field.

Since I don't know how your tables are structured or what information
in the phone number table would let you identify which member goes
with which phone, it's a bit hard to be specific!

John W. Vinson[MVP]
 
Back
Top