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

    Count on Long Text field in report

    I have a report that has a Long Text field (ACCESS 2016). I need to count on the long text field. How do I do that? I am not able to group on the Long Text.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Tell us more about your proposed database. Give an example of "count on the long text field".

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You could try textbox in report header or footer: =Count([fieldname])
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 24
    Last Post: 03-12-2019, 08:02 PM
  2. Replies: 15
    Last Post: 02-17-2019, 06:19 PM
  3. Add long text field to table or not?
    By PDilly in forum Access
    Replies: 17
    Last Post: 01-30-2019, 03:48 PM
  4. Long Text field in report
    By QuyitLady in forum Reports
    Replies: 11
    Last Post: 01-24-2018, 01:00 PM
  5. how much text in long integer field?
    By accessmatt in forum Database Design
    Replies: 10
    Last Post: 12-22-2014, 03:54 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