This will round everything UP to the nearest 50,000 mark: (Ceiling(price/50000) * 50000)
You can add extra string manipulations to produce the text that you want. I am no MS Acess expert, but the above functions should be available. :P ------------------------------- 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
