Results 1 to 4 of 4
  1. #1
    Join Date
    May 2014
    Posts
    98

    Red face Unanswered: Showing count of different values of a combo box

    I have a report on which I have a combo box showing text value as open issues and closed issues. What I want to do is on the report in a text box show count of open issues and closed issues separately. Please help

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    a combo box on a report?
    ..thats a new one on me..... you can't select a value on a combo box in a report, so its a pointless control. Ive seen people use listboxes if there are a very limited number of options and the list box was sized to display that number of rows, but as with the combo box you cna't select a value so its a pointless control.

    if you need spearate counts then consider using a domain function
    OR insert a report/group footer that COUNTs(acolumn)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2014
    Posts
    98

    Showing count of different values of a combo box

    I created a query
    SELECT tblMainTWTTPSheet.txtStatus, Count(tblMainTWTTPSheet.txtStatus) AS CountOftxtStatus
    FROM tblMainTWTTPSheet
    GROUP BY tblMainTWTTPSheet.txtStatus
    HAVING (((tblMainTWTTPSheet.txtStatus) Is Not Null) AND ((Count(tblMainTWTTPSheet.txtStatus)) Is Not Null));

    and place it on a form and on the report placed it as subform. Which shows up every open and closed issue however report is already based on a query which filter records. Now what i want is subform to show records as per the filter values on the report.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    please do not start a new thread for the same question
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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