check for duplicates within a time frame

[johnmac42]

I have written a service management database. I want to create a report that will look up a serial number between 2 dates. Check to see if that serial number has previously been in for repair. If the s/n has been in previously check to see if the date shipped on the previous service order was <= 30 days of the date received on the new service order. If so I would like it included in the report. I am not sure that this is the best way to proceed, but I have alreadyc reated a duplicates query that looks up any serial numbers between the start date and the end date. What I do not know is how to make the comparison between the records found, and enter it on a report.

database structure
table=service orders
field=so#
field=serialnumber
field=dateshipped
field=datereceived

 

[Remou]

This post would be better in Forum701, because you will need a more complex query before you create this report. It seems that you need a nested query to get the previous service date. A little sample data with a indication of what the return should be would help.