Hi Joe. All is well. Use DMAX to get the date of the most recent note, and then use DLOOKUP to get its ID. Then use that ID to lookup any other details you need.

LatestDate = DMAX("DateField","NoteT","PermitID=" & PermitID)
LatestID = DLOOKUP("NoteID","NoteT","DateField=#" & LatestDate & "#")
NoteText = DLOOKUP("NoteText","NoteT","NoteID=" & LatestID)

This would actually make a really good TechHelp video. A few other people have asked me similar questions recently.

I can see from your badges that you're not into the Developer classes yet. This same technique will work as calculated fields in a query. However note that domain aggregate functions like DLOOKUP and DMAX will slow things down a lot if you have a big query with a lot of records. Depending on how your tables are set up you could use an aggregate query with MAX to determine that date, and that would save you some time. I'll try to cover this in the TechHelp video. No promises on when I'll get it finished though. The list is super long.

See, Alex, the badges came in handy! Great idea.

Copy Last Record

Hello Richard,
Glad all is well! Unfortunately I simply have not had the time to get back into your classes. Hope to focus on them in the very near future. I actually can't wait to get to the Developer level. That said, your Aggregate Query suggestion using the MAX function worked perfectly, your help is very much appreciated.
Have a Great Rest of your Day.

My pleasure. Glad it worked well for you.