K
KHogwood-Thompson
Hi,
I have a database that has linked tables to a finance package. One of the
tables has a query based on the table that returns subcontractors names and
addresses and insurance details that we have on file for each.
When insurance details are updated, the table adds a new record rather than
overwrites, this is something that I cannot control. However the underlying
query I can and I would like for multiple records to only show one record per
subcontractor based on the latest expiry date of the insurance.
The table name and fields are as follows:
Query: ExpiredInsurance
Table: CISSubCont
Fields: Ref, Name, Ins, Expiry
I only want these fields returned for each unique ref, but the record that I
want must be latest insurance expiry date (Expiry field).
I have a database that has linked tables to a finance package. One of the
tables has a query based on the table that returns subcontractors names and
addresses and insurance details that we have on file for each.
When insurance details are updated, the table adds a new record rather than
overwrites, this is something that I cannot control. However the underlying
query I can and I would like for multiple records to only show one record per
subcontractor based on the latest expiry date of the insurance.
The table name and fields are as follows:
Query: ExpiredInsurance
Table: CISSubCont
Fields: Ref, Name, Ins, Expiry
I only want these fields returned for each unique ref, but the record that I
want must be latest insurance expiry date (Expiry field).