ROTECTED]>
Sent: Monday, February 17, 2003 5:02 AM
Subject: Re: Need Distinct and Min...
> * Lewis Watson
> > I have a table with three fields. In the first field I have a range of
> > numbers 1-20; all repeated more than once. In the third field I have a
> > number ranging f
On Monday 17 February 2003 04:20, Lewis Watson wrote:
> I have a table with three fields. In the first field I have a range of
> numbers 1-20; all repeated more than once. In the third field I have a
> number ranging from 1 to 20 in each row. I need to choose the
> lowest amount in the thi
* Lewis Watson
> I have a table with three fields. In the first field I have a range of
> numbers 1-20; all repeated more than once. In the third field I have a
> number ranging from 1 to 20 in each row. I need to choose the
> lowest amount in the third column for each distinct value in the
I have a table with three fields. In the first field I have a range of
numbers 1-20; all repeated more than once. In the third field I have a
number ranging from 1 to 20 in each row. I need to choose the
lowest amount in the third column for each distinct value in the fist
column. Will some