Hello all,
I have the table below (see screenshot) and I need a way to sort the transactions by payment type and combine it on one table as a single record.
Basically I want to take the data and put it on a table with the following fields:
date = date
Amex = American Express Total
Cash = Cash total
Visa = Visa Total
Mastercard = Mastercard
How would I do this? I know its a query but im at a loss on the way.