Results 1 to 7 of 7
  1. #1
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28

    create a count field in report

    I have am M Access 2016 report in which there is a text field. I would like to calculate on that text field and do a count on that field. How do I do that?

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    In which section is this text field placed on the report?
    What exactly are you trying to count?

  3. #3
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28
    Quote Originally Posted by JoeM View Post
    In which section is this text field placed on the report?
    What exactly are you trying to count?
    --- the text field is in the detail portion of the report ; however, I'd like to put the calculated field in the group footer of the report. The text fields comprise common phrases like "waiting for reply". I'd like to calculate how many "waiting for reply" comments I have

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

  5. #5
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28

    Thumbs up

    Quote Originally Posted by JoeM View Post
    Many thanks.

  6. #6
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28
    I imported the original table from an EXCEL spreadsheet. It is my preference to group against the Large Text field since the data is entered "generically" and actually serves my needs best.. For example the field contains such information as "Collected and assigned" or "Collected and Unassigned" or " no assignment required due to xxxxxx" or "assignment required due to xxxxx". These are the only entries entered in the large text field. So, I would like to group them by this field and then in the details include fields that are associated with the group like " employee name", "date initiated", "date completed". I would then like to COUNT how may of each Large Text field group there are.

    I am not able to do any of this at the moment.

  7. #7
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 07-03-2017, 11:24 PM
  2. Replies: 1
    Last Post: 06-20-2017, 09:00 AM
  3. Replies: 3
    Last Post: 01-13-2016, 12:34 PM
  4. Create a Field to Calculate Unique/Distinct Count
    By MikeNewAccessUser in forum Queries
    Replies: 3
    Last Post: 03-06-2015, 08:39 AM
  5. Replies: 3
    Last Post: 01-04-2015, 03:00 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
  •  
Other Forums: Microsoft Office Forums