Grouping Levels

  • Thread starter Thread starter Sandy Hayman
  • Start date Start date
S

Sandy Hayman

I have a fairly simple financial report based off a query. The query results
looks like this:

ID Amount PMethod Description
1 50.00 Credit Card Membership
2 29 Cash Donation
3 15 Cheque Books

In my report, I want to group by PMethod however, I want cash and cheque
combined in the first group and credit card in the second group. Is this
possible? I am sure I have done something similar before but can't remember
how.

Thanks in advance
 
Sandy said:
I have a fairly simple financial report based off a query. The query
results looks like this:

ID Amount PMethod Description
1 50.00 Credit Card Membership
2 29 Cash Donation
3 15 Cheque Books

In my report, I want to group by PMethod however, I want cash and
cheque combined in the first group and credit card in the second
group. Is this possible? I am sure I have done something similar
before but can't remember how.

Thanks in advance
Click to expand...

In your query add a calculated column like...

IsCreditPayment: IIf(PMethod="Credit Card", True, False)

Group on that field in your report.
 
Back
Top