Joel,
Thank you very much. I gave that a try and it worked perfectly. It
definately was the distinct keyword I was missing.
Thanks Again,
Steve
Joel Burton wrote:
>
> Will DateStamp being the date of insertion? If so, is it that you want
> the record for the most recent (largest) datesta
> Ok here is the problem.
> Table: Widgets
> Fields: Unique_Key, DateStamp, Batch_Number, Instructions.
>
> Basic Select Statement:
> select Unique_Key from Widgets where Batch_Number>='inputedvalue'
>
> Problem:
> Some Batch_Numbers might be duplicated over a period of time. I want
> to selec
Ok here is the problem.
Table: Widgets
Fields: Unique_Key, DateStamp, Batch_Number, Instructions.
Basic Select Statement:
select Unique_Key from Widgets where Batch_Number>='inputedvalue'
Problem:
Some Batch_Numbers might be duplicated over a period of time.
I want to select the most recent of
