filter query using subtables

[Matt Edwards]

I'm trying to create a query that returns the contact info
for uncollected pledges. I want to track uncollected
pledges using a "pledge" subtable and a "donation"
subtable.

It seems like the easiest way to create the query would be
to display ContactID (the primary key), based on criteria
saying

(pledge <> " ") AND (donation = " ")

That just pulls up a whole lot of nothing.

Other times I try listing the fields, "pledge"
and "donation," where "donation = " " ". But instead of
pulling up all the donors for whom the donation is blank,
it pulls up all the donors who have donated (ie, the
COLLECTED pledges).

Any ideas?

-ME

 

[John Vinson]

I'm trying to create a query that returns the contact info
for uncollected pledges. I want to track uncollected
pledges using a "pledge" subtable and a "donation"
subtable.

It seems like the easiest way to create the query would be
to display ContactID (the primary key), based on criteria
saying

(pledge <> " ") AND (donation = " ")

If you want to find those records which exist in the Pledge table but
have no corresponding record in the Donation table (and I'm not sure
of your table structure so I'm a bit shaky on the suggestion here!)
use the Unmatched Query Wizard to build a Query on the two tables to
do so.

I replied in another newsgroup, probably having misread the message to
say that you had fields Pledge and Donation in the same table. PLEASE
DO NOT MULTIPOST. If you should want to post a message to two or three
(no more) *appropriate* newsgroups (and .forms is *not* appropriate
for this query question) then crosspost by typing all the newsgroup
names in the Newsgroups line.