If price is an integer you should use: (Ceiling(price/50000.0) * 50000) To enforce floating point operation. :)
------------------------------- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:16 PM To: CF-Talk Subject: SOT: SQL I've got a price column in an Access DB. I'm wondering how to include the price rounded to the nearest 50,000 in my query. I'm basically wanting to group the output by price in $50,000 increments. If there's a better way, I'm open to that, too. For instance: 250,000 and under ..... 200,000 and under ..... 150,000 and under .... Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
