Hi Maureen, I really like your thinking, but I'm not sure that will achieve what I need, I'll definitely test it out tomorrow though, many thanks for your input, much appreciated.
One niggle is that having to use two queries really messes up using the Ranking. Jenny -----Original Message----- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 01:28 To: cf-talk Subject: Re: Problem Using QueryNew No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/11 07:36:00 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm