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 <= 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 already
Created 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=serial number
field=date shipped
field=date received
Created 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=serial number
field=date shipped
field=date received