Help with duplicates query

I have a table with various fields, two of which are "date" and "serial number". I'm trying to construct a query which will return all records unless there are multiple matches in the "serial number" field , in which case the following should happen;
duplicate "serial number" entries should be checked to see if they fall within 5 days of each other as defined by the "date" field. If so, the newer record should be discounted from the query but not deleted from the table.

Given the table serial number date other fields
123 01/01/01 xxxxx
123 07/01/01 yyyyy
123 08/01/01 zzzzz

the query result should be
serial number date other fields
123 01/01/01 xxxxx
123 07/01/01 yyyyy

Can anyone help with this?

tintin

Look at the attached DB,

Look at table1
then run query 2

It takes two queries to do what you want

S-

Thanks a million S. I modified your solution to fit my db and it works perfectly. Nice to have you around.
Tintin