Membership renewal query

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

I have an Access 2000 database being used to keep track of membership for a
non-profit organization. All memberships expire at the same time each year,
so I have set it up as follows:

tblMembers: contains names, addresses, etc. (primary key: MemberID)
tblYears: contains a list of membership years (2002-2003, 2003-2004,
2004-2005)
tblMemberships: contains an entry for each member for each paid year
(fields: MembershipID, MemberID, Year, and some stuff that's useful to us
for tracking purposes)

Using this, it is very easy to query for all current members. However, I
have been unable to figure out how to query for members who need to renew
(i.e., members who paid for 2003-2004 but not for 2004-2005).

If anyone has a suggestion, I'd appreciate it. Thanks in advance.

=Max=
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Members who haven't paid for year 2004:

SELECT M.MemberID, M.MemberName
FROM tblMembers As M LEFT JOIN tblMemberships As MS
ON M.MemberID = MS.MemberID
WHERE MS.Year <> 2004


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQCQcfYechKqOuFEgEQLX8gCg0txB+xCpttU3Iq2+OiaYy6y954MAoKj6
jnHf9RJxS0OIdzx4XWKwqNZA
=yYeO
-----END PGP SIGNATURE-----
 
Yeah, I've come up with something like this, but it doesn't show me only
those members who DID pay in 2003.

=Max=
 
Back
Top