Grouping Levels

[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

 

[Rick Brandt]

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

In your query add a calculated column like...

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

Group on that field in your report.