S
Steven R via AccessMonster.com
We have revolving contracts with vendors that roll-over into a new contract
with a new cont# - I want a query that only shows one contract record per
vendor, based on which record has the latest contract end date.
I think DMAX just give the latest record based on the criteria
My fields are:
Vendor Name
Contract Number
StartDate
EndDate
with a new cont# - I want a query that only shows one contract record per
vendor, based on which record has the latest contract end date.
I think DMAX just give the latest record based on the criteria
My fields are:
Vendor Name
Contract Number
StartDate
EndDate