RE: Summing certain groups of values on a report
From: burg (burg_at_discussions.microsoft.com)
Date: 10/27/04
- Next message: Rick B: "Re: Bringing Info From Two Table Together"
- Previous message: Terry: "Re: NOT IN operator not working with subquery."
- In reply to: ChuckW: "Summing certain groups of values on a report"
- Next in thread: quixote: "RE: Summing certain groups of values on a report"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 07:59:15 -0700
You can create another query that calculates this total, visa + master card,
and then create a subreport in the report footer of this query. This was the
simplest way i found to solving the problem.
You could try and create a text box that adds the values of the total visa
and the total mastercard text boxes but I couldn't get it to work.
Hope this helps.
"ChuckW" wrote:
> Hi,
>
> I am creating an access report on daily credit card
> transactions. I have a field called CC_Type which has
> values of either AMEX, Master Card or Visa. I have
> grouped the report by this field - there is a CC_Type
> Header now. Under the details section, the are fields
> such as CardNumber, CustomerName, and Amount. In the
> CC_Type Footer I have summed by the card type. So all of
> the Amex transactions are added together, all of the
> Master Card are added together and all of the Visa are
> added together. I then have a report footer which give a
> daily total and sums all three cards.
>
> What I want to do is in the report_footer or somewhere
> else, I want to sum the Master Card and Visa transactions
> together. So there will be a Visa/MasterCard sum and
> then the daily total. Is there a way to do this?
>
> Thanks,
>
> Chuck
>
- Next message: Rick B: "Re: Bringing Info From Two Table Together"
- Previous message: Terry: "Re: NOT IN operator not working with subquery."
- In reply to: ChuckW: "Summing certain groups of values on a report"
- Next in thread: quixote: "RE: Summing certain groups of values on a report"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
