Contributions and Solicitations for a given fiscal year

OK, it was working with the other connections previously mentioned until I added the TX_CUST_MEMBERSHIP table.  Any ideas as how to adjust for adding the TX_CUST_MEMBERSHIP table? 

These are the fields I am trying to summarize, I am summing the contributions and asking for the max memb exp date:

Regards,

James E. Fairfield

Database Administrator

james.fairfield@attpac.org

(214) 978-2868 Office

(214) 954-9936 Fax

AT&T Performing Arts Center

2100 Ross Avenue, Suite 650

Dallas, Texas 75201

www.attpac.org

Important/Confidential: This communication and any files or documents attached to it are intended for use only by the named recipient/addressee. It may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the named recipient/addressee of this communication, you are hereby notified that copying, distributing, or otherwise using this communication is strictly prohibited. Any review, retransmission, dissemination or other use of, or action taken in reliance upon this information by persons or entities other than the named recipient/addressee is prohibited. If you received this communication in error, please notify the sender by reply e-mail and delete and destroy all forms of this communication (electronic or paper). Thank you.

I'm guessing that you have some patrons who have multiple solicitations within the same campaign (or fiscal year) which would cause your contribution totals to be higher than expected (due to a Cartesian result when you join to the solicitation table).

You will need to decide how you want to deal with this if it is the case.  If someone has two solicitations, which one do you want to include in your data set? Alternately, you could try joining t_solicitation and t_contribution using customer_no, campaign_no and designation.  That should eliminate the problem as well.

OK, it was working with the other connections previously mentioned until I added the TX_CUST_MEMBERSHIP table.  Any ideas as how to adjust for adding the TX_CUST_MEMBERSHIP table? 

These are the fields I am trying to summarize, I am summing the contributions and asking for the max memb exp date:

Regards,

James E. Fairfield

Database Administrator

james.fairfield@attpac.org

(214) 978-2868 Office

(214) 954-9936 Fax

AT&T Performing Arts Center

2100 Ross Avenue, Suite 650

Dallas, Texas 75201

www.attpac.org

Important/Confidential: This communication and any files or documents attached to it are intended for use only by the named recipient/addressee. It may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the named recipient/addressee of this communication, you are hereby notified that copying, distributing, or otherwise using this communication is strictly prohibited. Any review, retransmission, dissemination or other use of, or action taken in reliance upon this information by persons or entities other than the named recipient/addressee is prohibited. If you received this communication in error, please notify the sender by reply e-mail and delete and destroy all forms of this communication (electronic or paper). Thank you.

I'm guessing that you have some patrons who have multiple solicitations within the same campaign (or fiscal year) which would cause your contribution totals to be higher than expected (due to a Cartesian result when you join to the solicitation table).

You will need to decide how you want to deal with this if it is the case.  If someone has two solicitations, which one do you want to include in your data set? Alternately, you could try joining t_solicitation and t_contribution using customer_no, campaign_no and designation.  That should eliminate the problem as well.