Most Recently Dated Record

[sc6678]

I have two tables- Facilities and Inspections. Each Inspection record relates to one facility, but a single facility may have many inspections. Each inspection has a Date of Inspection Field. I'd like to create a field on the facility record that shows the date of the most recent inspection. I'm a novice Access user, but it seems like it should be do-able, I'm just not sure where to start. Any ideas on how to do this? Thanks in advance!

[aytee111]

Calculated fields are not stored on tables, they are recreated when they are needed. To find the most recent date, create a query and click on the totals icon on the top. You will then Group By the facility and do Max of date.

[Bulzie]

Also maybe try using DMax function when you need this value and not storing anything in tblFacility as aytee111 said. Something like:

me.LastInspectDate = DMax("[InspectionDate]", "tblInspections", "[FacilityID] = " & Me.FacilityID)