Hello, I have a table that looks something like this.
Com1 gender fname lname 001 M Matt Smith 001 M Bill Wright 005 F Kara Brown 005 M Mike White What I need to do is pull a record from each "com1" group that meets my where criteria. Say from above I want all the males. I would want the answer to be 001 M Matt Smith 005 M Mike White Or 001 M Bill Wright 005 M Mike White I don't care which record I just want ONE per com1 id meeting the criteria. I tried using distinct but that will not work as you have to list all the field names out and then group but the none distinct ones which gives me all the com1's meeting the where criteria. Any idea's? Jeremy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241120 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
