Calculating totals based on option button

[Troy1977]

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
Money Order =3

The report needs to calculate all cash, check and moneyorder transactions separately and then add them together for a grand total and display them on a report.

Any help would be greatly appreciated.

Troy1977

 

[ajetrumpet]

there isn't much information here to go off of. Is there more transaction types than those 3 in your table? if not, just use a DSUM() function in a text box on your report. If so though, you'll have to use the criteria section of the DSUM() funciton in the box. that sounds like what you need really. Maybe take a look at the summation text box on the main form in the following example to help out:

http://www.access-programmers.co.uk/forums/showthread.php?t=137158

 

[Rich]

=Sum(Iif([MyField]=1,[amount],0))
=Sum(Iif([MyField]=2,[amount],0))

etc

 

[Troy1977]

Thanks Rich, that worked perfectly...