Hello -
I have a report in Access 2008 and i have a call records and a field called Total, and another field called Status... in the total field i have numbers and in the status field i have [closed] and [open] i want to sum the total amount that was closed. how do i get the report to show me the total for all that was closed
example:
Records: Total: Status
Company A 3 Closed
Company B 4 Open
Company B 3 Closed
TOTAL CLOSED = 6
TOTAL OPEN = 4
I have a report in Access 2008 and i have a call records and a field called Total, and another field called Status... in the total field i have numbers and in the status field i have [closed] and [open] i want to sum the total amount that was closed. how do i get the report to show me the total for all that was closed
example:
Records: Total: Status
Company A 3 Closed
Company B 4 Open
Company B 3 Closed
TOTAL CLOSED = 6
TOTAL OPEN = 4