Hi Will, So you have three tables included in the group report, what are you linking the tables on?
I'm guessing you need inner or outer joins. If you post your main fields for each of the three tables, especially with the primary id field you are using to link them and I'll have a crack at it :-) Jenny -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 20 November 2005 17:53 To: CF-Talk Subject: Re: Grouping problems >Hi Will, if you add an ORDER BY to your query on the field(s) you want to >group on it will usually take care of this problem. > Justin, that's the first thing I tried but it made things get wacky in the select menu. It added menu items - an item for small, for black, etc... along with all the correct ones. Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
