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
