Jump to content

The forums are in maintenance (read-only) mode until further notice. If you search these forums, you may find the answer you need. Otherwise, Google and Stack Overflow are reliable resources; arguably faster ones, too. I apologize for any inconvenience. (For those concerned--and thanks for being so thoughtful, there's no cause for alarm, but after 12+ years running these forums in my "spare time", I'm opting for a much deserved break to recharge my depleted batteries.)


Can Columns Hold A Range Of Values

  • Please log in to reply
1 reply to this topic

#1 margaux


    Advanced Member

  • Members
  • PipPipPip
  • 453 posts

Posted 20 March 2012 - 12:15 PM

I need a table to hold a range of decimals and their corresponding meaning e.g.

0.00-4.99 = poor
5.00-9.99 = average
10.00-14.99 = good
above 15.00 = excellent

what would be the best way to set up this table?
  • 0

#2 Larry



  • Administrators
  • 4,399 posts
  • LocationState College, PA (USA)

Posted 21 March 2012 - 6:34 AM

The best way would be to create a new table, "ranges": range_id, min, max, meaning.
  • 0