var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Totaling only part of a Combo Box, can it be done?
I have a report that I need to the loan, with it's issues, and the issues risk rating. My example is as follows:
Field 1 Text - Account Name:
Field 2 Text - Description of Issues:
1)No Title Insurance or Certificate.
2)No search on property record.
3)No copy of deed.
Field 3 Combo Box - Risk Level for Issues:
3-High, 2-Moderate, 1-Low
My Report needs to show that John Smith had 1 High issue, and 2 Non-High issues. How do I get an unbound text box to show the total of part of the Combo Box?
there needs to be a 1:1 between Issues and Risk. Right now you display 3 records for Issues but only 1 record for Risk (with 3 choices).....
put a Risk field in the Issue record.....
once that is there; then in Reports one can count the "Highs" vs "Moderates" etc in group sums.
www CahabaData com
Tags for this Thread