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