Andrew Scott wrote: > Jim any idea how to add this to that script > > 1-3 days = $200 > 4-5 days = $350 > 6-6 days = $0 > 7+ days = $30 per day > > So 2 Days would be $200 and 6 days would be $350 > 10 days would be 4 * 30 + 350 >
I'm still thinking that you need to get the data transformed into something a little more usable...so that in a case like above... 1 - 200 2 - 0 3 - 0 4 - 150 5 - 0 6 - 0 7 - 30 8 - 30 9 - 30 10 - 30 etc... Then your total is just a simple sum(). While I believe in keeping a lot of data processing on the db side of things, you really need to have the data presented in a way that supports that...otherwise the processing starts getting too complicated (as you are seeing). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2660 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
