Re: unique by field issue

2005-07-01 Thread SGreen
Seth Leonard <[EMAIL PROTECTED]> wrote on 07/01/2005 04:43:05 PM: > > I constantly bump up against this issue and am looking for a good > solution. I want a query that will return multiple rows, but only one > row per unique identifier in one field. > > > > For instance, if I have the followi

unique by field issue

2005-07-01 Thread Seth Leonard
I constantly bump up against this issue and am looking for a good solution. I want a query that will return multiple rows, but only one row per unique identifier in one field. For instance, if I have the following table: Name | Food | Eat_Date Bob | Hot Dog | 2005-06-25 Jan | Pizza | 2005