Results 1 to 2 of 2
  1. 05-28-2014, 06:53 AM #1
    jj1
    jj1 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    128

    Unhappy 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
    Reply With Quote Reply With Quote
  2. 05-28-2014, 07:08 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Make a query (Q2) that counts each issue. In your Report query (Q1) add the Q2 but LINK THEM on ISSUE.
    Bring the counted fields into the show list and you can now report them.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Data fields not showing on report (Yes/No, combo boxes and datepickers are showing)
    By khughes46 in forum Reports
    Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  2. Combo Box has right amount of values, but they aren't showing up
    By Matzer in forum Access
    Replies: 8
    Last Post: 12-18-2013, 03:00 PM
  3. Combo Box filter not showing values
    By Chatholo in forum Forms
    Replies: 7
    Last Post: 08-01-2013, 08:53 AM
  4. Combo Box showing Blank Values
    By glen in forum Access
    Replies: 5
    Last Post: 11-24-2012, 09:44 AM
  5. Showing Count in form field
    By randolphoralph in forum Forms
    Replies: 11
    Last Post: 05-17-2010, 03:52 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums