D
deb_anderson
I have modified an Access Template called Order.mdb to record all Ticket
Orders and Donations for a fundraiser we're hosting. All of the individuals
for whom tickets/donations have been purchased are listed as "products" in a
separate table. Each "product" has received either ticket sponsorships
and/or donations.
I did a cross tab which reflects each individual person's name and notes how
many tickets or donations were given in their honor. Each person will
receive notification based on whether they've received a ticket, a ticket and
a donation over $15, ticket w/donation under $15 or a donation under $15. To
simplify this mailing, I want to know who fits within each category: (ticket
only, no donation), ticket and a donation over $14.99, ticket and a donation
under $15, donation only above $15 and donation only below $15.
Question: I have figured out how to get a summed crosstab with query
results for all who received donations <$14.99, donations >$15, ticket
orders, etc., but I can not get the crosstab to acknowledge all who received
tickets AND a donation. (In some cases, they've received both.) I have a
designation in my table for Saletype (1=donation, 2=ticket). Can someone
please help?? Thanks so much.
Orders and Donations for a fundraiser we're hosting. All of the individuals
for whom tickets/donations have been purchased are listed as "products" in a
separate table. Each "product" has received either ticket sponsorships
and/or donations.
I did a cross tab which reflects each individual person's name and notes how
many tickets or donations were given in their honor. Each person will
receive notification based on whether they've received a ticket, a ticket and
a donation over $15, ticket w/donation under $15 or a donation under $15. To
simplify this mailing, I want to know who fits within each category: (ticket
only, no donation), ticket and a donation over $14.99, ticket and a donation
under $15, donation only above $15 and donation only below $15.
Question: I have figured out how to get a summed crosstab with query
results for all who received donations <$14.99, donations >$15, ticket
orders, etc., but I can not get the crosstab to acknowledge all who received
tickets AND a donation. (In some cases, they've received both.) I have a
designation in my table for Saletype (1=donation, 2=ticket). Can someone
please help?? Thanks so much.