Results 1 to 10 of 10

Thread: Count numbers from a memo

Threaded View

  1. 03-26-2015, 05:15 PM #6
    Allan Murphy
    Allan Murphy is offline Registered User
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    You will need to use LEN and build a loop and using INSTR to find the first comma, then add 1 to your counter use INSTR again but move the start point
    of the to the next position after the comma, Repeat this process until the end of the memo.

    I have attached a zip 2013 version of the database that will count the numbers. The query passes the memo field to the module. The module manipulates memo field to perform the number count.

    If you cannot open the database I will post the code on the forum.
    Attached Files Attached Files
    Allan
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules