I am trying to reduce data from a mini-marathon.
I have 4 tables each with Two Alpha fields.
Field1 contains the code number of a runners "Toe Chip" (An Electronic ID
chip - A7field).
Field2 contains the time of day "hh:mm:ss.
As the runners pass the sensor, the chip number and time of day is recorded
by the hardware.
Problem: Runners often wander back thru the chute thereby creating a second
(or more) record.
Is there a query method that will take the first value received and reject
all others *without* changing the order of the codes?
I have created another column which I have numbered the arrival order so I
can re-arrange the data after a query.
Any suggestions?

Chuck [Sbc) wrote:
Try either of these:

Using QBE


Using SQL

SELECT DISTINCT field1, MIN(field2) AS first_time
GROUP BY field1
ORDER BY field1

Ed
I'm embarrassed! I couldn't see the forest for the trees! The only
modification to your suggestion is to sort on the time!
Thanks for the wake up call!
Chuck