var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sum of combo box access reports
I'm designing an access report, and in one field or text box I need to be able to display the sum of a combo box.
Field text17 I want to display the sum or total of all values of the combo box that equal the word "Won"
Field text18 I want to display the sum or total of all values in the combo box that equal the word "Lost"
The combo box is named won/lost
Does anyone know what coding I could use in the access report to make this happen? Thanks in advance.
You can't sum a control, but you can sum a field in the report or group footer: