Jump to content



Photo

Can Columns Hold A Range Of Values


  • Please log in to reply
1 reply to this topic

#1 margaux

margaux

    Advanced Member

  • Members
  • PipPipPip
  • 449 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

Larry

    Administrator/Writer

  • Administrators
  • 3,525 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