Cash Total and Credit Total in separate columns

[rajdh75]

Hello,
I have made a query from 3 tables.
It has Date of sale, Invoice ID, Customer ID, Type of Sale and Sum of Total columns.
sum of total is arrive from Group By sum method.
I want separate Cash column which will have Cash Total and separate Credit column which will have Credit Total.
From this



Date of sale InvoiceID CustomerID TypeofSale SumofTotal
30/04/2020 1 1 Cash 0.00
30/04/2020 2 7 Credit 300.00

Like this -

Date of sale InvoiceID CustomerID Cash Credit
30/04/2020 1 1 300.00 0.00
30/04/2020 2 7 0.00 300.00

How can i achieve this ?

Thanks.

[kd2017]

Look into crosstab queries.
https://support.microsoft.com/en-us/...0-2cd8484667e8

See attached db.

[pbaldy]

Another option, a query field like:

Cash: IIf(TypeOfSale = "Cash", AmountField, 0)

[rajdh75]

Thanks kd2017 for your solution.