Results 1 to 2 of 2
  1. #1
    baarrnnee is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    3

    Finding Entries with no contributions

    I am trying to create a report that will show members that have not made any contributions the past year.



    I already have a report and query that gives me all members who contributed during the year along with the totals in each category and a grand total for the year for each member.

    The report omits all those who have not made any contributions for the year.

    What I would like is to be able to report the opposite as well, is a separate report that would give me a list of all who have not contributed this year.

    How do I pull out that information? I'm stumped!

    I have 2 tables in the database, one for membership information and a second for contribution categories and amounts. They are linked by the member unique ID

    thank you,

    Karl

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Do a left Join from the members table to the payments.

    Under the payments MemberID field put the criteria in as Is Null

    Code:
    SELECT tbl_Members.* Left Join tblPayments On tbl_Members.MemberID = tbl_Payments.MemberID 
    WHERE tbl_Payments.MemberID Is Null
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 07-10-2018, 09:54 AM
  2. Combined Contributions
    By ZD8062 in forum Access
    Replies: 1
    Last Post: 03-13-2015, 11:37 AM
  3. Replies: 3
    Last Post: 02-22-2013, 11:34 PM
  4. Finding and counting (not records but entries)
    By gpbanseo in forum Queries
    Replies: 3
    Last Post: 07-14-2011, 04:35 AM
  5. Replies: 0
    Last Post: 08-10-2010, 01:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums