Welcome to Forums Sign in | Join | Help | Forums
in Search


Query - Summary of Gift + Last Gift Date

Last post 03-05-2009 8:44 AM by Margaret Whitaker. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-03-2009 6:22 PM

    • Margaret Whitaker
    • Top 75 Contributor
    • Posts 99
    • Organization: Novant Health
    • Products:  The Raiser's Edge, The Researcher's Edge

    Query - Summary of Gift + Last Gift Date

    How do I pull a query on the following criteria:

    Cumulative Giving for Donors who have given to Fund A (I know how to do that part) and also include in the final report the last gift date and last gift amount for Fund A.  Thanks!

     

    Margaret Whitaker
    Donor & Financial Services Coordinator
    Presbyterian Hospital Foundation
  • 03-04-2009 9:58 AM In reply to

    • Drew Allen
    • Top 10 Contributor
    • Posts 514
    • Organization: Children's Hospital of Philadelphia
    • Products:  The Information Edge, The Raiser's Edge

    Re: Query - Summary of Gift + Last Gift Date

    It sounds like you are using query for your report, but query is not a reporting tool.  You need to be using export for your report.  The Last Gift fields in query and export behave differently.  What you want can only be done through export.

    Drew

    J. Drew Allen
    The Children's Hospital of Philadelphia
    Filed under: ,
  • 03-05-2009 8:44 AM In reply to

    • Margaret Whitaker
    • Top 75 Contributor
    • Posts 99
    • Organization: Novant Health
    • Products:  The Raiser's Edge, The Researcher's Edge

    Re: Query - Summary of Gift + Last Gift Date

    Yes, I remembered it shortly after I placed the post.  Due to a late night brain freeze, I became a total blank!  Thanks for the response.

    Margaret Whitaker
    Donor & Financial Services Coordinator
    Presbyterian Hospital Foundation
Page 1 of 1 (3 items)