Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    64

    Unanswered: Advanced formula that changes saved number

    I need a field on my form where the user can enter a size (this could be any positive number with decimals). However, I need another field to total this field along with others not from the size entered but from a number that correlates to the size. For instance, sizes 1-3 equal 1, sizes 3-6 equal 2, and sizes greater than 6 equal 3. The numbers 1, 2, & 3 are what need to be sent to the total field and used in the equation. How do I convert the number to these correlating numbers?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    personally I'd use a table that translated sizes 1,2,3..10 to A,B,C
    if for no other reason than allowing new sizes or reconfiguring the translation is done by changing the data in the table, not be programming effort
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this 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
  •