Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    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:
    Smith, John

    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?

  2. #2
    Join Date
    Oct 2009
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts