Results 1 to 2 of 2

Thread: Query question

  1. #1
    Join Date
    Feb 2013

    Unanswered: Query question

    I have been developing a database for a non-profit music organization.

    Having now imported all their Patron, Donor, and Ticket sale information, I would like to create a query to help their developing team locate frequent ticket buyers who have not been giving donations. I have the database organized in 3 tables, 1 with patrons (each with primary key), one with donations (linked by the patronsID field) and one with ticket sales (also linked to PatronID field).

    In creating the query, I have attempted to organize by PatronsID while creating a count >1 for PatronsID for ticket sales and <=1 for Donations (PatronsID). This has not been returning results even remotely close to what I intend. Does anybody have suggestions to make this query select my desired records? Thanks

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Use the query designer. There is a wizard that will do what you want.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts