I'm trying to build a report with 4 separate totals based on the same [Amounts] field.
What I've got is a table with a "Payment Type" field and an option group set to update this field with 1 of three options. I'm using option buttons to set this field with the following.
Cash = 1
Check = 2...