Search results

Yes, each table has multiple CalID's and mulptiple EquipmentID's :). BUT all EquipmentID's of one EquipmentType. Example: Cement Consistometer (EquipmentType) Calibration Table has 7 different CalID's (PressureCal, TemperatureCal, TimerCal, etc), and there are 5 consistometers units in the lab...

Thank you, vbaInet! I had the second option in mind, but I don't have enough VBA power to pull this off yet (I don't do access for living:)). The code could loop through the table collection just looking at tables ending with "CAL", selecting records with the latests date for those unique...

I have 30 tables in my Access database, 12 of them named ****CAL. Each of those 12 tables contain calibration records for equipment (hence name ending with "CAL"). All 12 tables have columns: Date, EquipmentID and CalID. Also I have a table with different equipment and accosiated calibrations...