hi dominic, ok thanks for your help. unfortunately it is not a query built from mysql that i could run the distinct on. it is a query that is built from the contents of a ms excel spreadsheet.
its ok ill look for another solution, your right, its a real shame QoQ doesn't work as it should as i was starting to see loads of uses for it!!! thanks again for your help richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
