Access Queries HELP!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deb_anderson@hotmail.com - 08 May 2005 04:21 GMT

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.

Reply to this Message

jl5000 - 08 May 2005 16:57 GMT

Add the SaleType to your group as "Row Heading" in the crosstab

Signature

jl5000
<a href="http://joshdev.com"></a>

> 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
[quoted text clipped - 16 lines]
> designation in my table for Saletype (1=donation, 2=ticket). Can someone
> please help?? Thanks so much.

Reply to this Message

Deb_Anderson@hotmail.com - 08 May 2005 19:56 GMT

Thank you for responding -- I appreciate it. I attempted to add SaleType in
as a Row Heading which resulted in all individuals being listed twice if they
received both tickets and donations. I still don't know how to write the
appropriate code to meet these conditions:

If an individual received a ticket AND a donation above (or below) $15.

In my original query, for example, Bill Smith received 2 tickets and 1
donation. The row heading is "Products" (each person) and there are 3 column
headings: Total of Quantity, "1" (donation) and "2" (tickets).

I need to figure out how to extract the dual ticket/donation holders.

Thanks in advance. I am a struggling novice who needs this for an
invitational printing (TOMORROW *smile*), so I appreciate your patience and
willingness to help me. I am NOT good with code, so step-by-step
instructions would greatly assist me. Thanks again. -- De
------------------------------------------------------------------------------------------------

> Add the SaleType to your group as "Row Heading" in the crosstab
>
[quoted text clipped - 18 lines]
> > designation in my table for Saletype (1=donation, 2=ticket). Can someone
> > please help?? Thanks so much.

Reply to this Message