No results when adding 2nd table to query

C

CRBI

Have 2 tables..one for Membership Data, one for Member Contributions. Have
Member form with Contributions as subform. Have field in Member table to
check (Yes/No field type) if I have solicited the member for renewal. Have
query to create new table for members who have renewed since a particular
date (I have to enter the parameter). This query works beautifully and pulls
out everyone who has renewed SINCE I solicited them. However, I need to add
the Contributions table to the query so that it will also tell me how much
they contributed. This should be easy, but everytime I add the Contributions
Table to the query (even without specifying any other criteria than already
specified) it returns no results. I'm completey flabbergasted as to the cause
because I've done plenty of multiple table queries before with no problems.
The two tables are related by Member ID numbers. Does anybody have any ideas
here of what might be going on and how I could over come it? I need to get
this done so I can turn it into a Make Table query and a report for a Board
Meeting coming up this coming Thursday night. Help is greatly appreciated!!!!
 
J

Jeff Boyce

In your query, are you joining the tables as "equi-join" (find when there
are MATCHING records in BOTH tables), or are you joint the tables to find
ANY in table2 that match ALL from table1?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
O

orange via AccessMonster.com

CRBI said:
Have 2 tables..one for Membership Data, one for Member Contributions. Have
Member form with Contributions as subform. Have field in Member table to
check (Yes/No field type) if I have solicited the member for renewal. Have
query to create new table for members who have renewed since a particular
date (I have to enter the parameter). This query works beautifully and pulls
out everyone who has renewed SINCE I solicited them. However, I need to add
the Contributions table to the query so that it will also tell me how much
they contributed. This should be easy, but everytime I add the Contributions
Table to the query (even without specifying any other criteria than already
specified) it returns no results. I'm completey flabbergasted as to the cause
because I've done plenty of multiple table queries before with no problems.
The two tables are related by Member ID numbers. Does anybody have any ideas
here of what might be going on and how I could over come it? I need to get
this done so I can turn it into a Make Table query and a report for a Board
Meeting coming up this coming Thursday night. Help is greatly appreciated!!!!

Please show us the SQL for the query.
 

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

Top