Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: totals but only if 4 digits

    i need to total some data, but only if the code contains 4 digits.

    by this i mean.

    Code --> A101 ----> Occur 35
    Code --> A101A ----> Occur 1
    Code --> A101B ----> Occur 5
    Code --> A101C ----> Occur 3
    Code --> A101D ----> Occur 5
    Code --> A101E ----> Occur 5
    Code --> A101F ----> Occur 5

    the total i need to be displayed is 24....

    you will see that the first code only has 3 digits in the code...

    Can this be done? if so how please

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    for instance with :

    if len(code)>4 and len(code)<6 then
    total = total +occur
    endif

Posting Permissions

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