Re: Deleting Duplicate Data Records

Chuck [Sbc) wrote:
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?



Try either of these:

Using QBE

| Field1 | Field2 |
| Check | CALC MIN AS first_time |


Using SQL

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

Relevant Pages

  • Deleting Duplicate Data Records
    ... Field1 contains the code number of a runners "Toe Chip" (An Electronic ID ... Is there a query method that will take the first value received and reject ... I have created another column which I have numbered the arrival order so I ...
    (comp.databases.paradox)
  • Re: Why so few 10ks?
    ... Every local festival, school group, club, has a 5K. ... runners as the 5K's, pay prize money in amounts that will attract the ... But much more difficult to organize, more volunteers, use of chip ...
    (rec.running)
  • Where do you play, Bike, Commerce or Hawaiian Gardens?
    ... The management is great. ... The chip ... runners, servers, and the rest of the crew are fantastic. ...
    (rec.gambling.poker)