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 these Batch Numbers.
--
Steve Meynell
Candata Systems