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!!!!

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top