Return Latest Related Record - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Return Latest Related Record

Chris Pardy

12 months ago

Hello, I thought this would be straight forward but I cant seem to get it working.
I have a Table [ProjectsT] and a table [ProjectNotesT]. the [ProjectNotesT] has related ID field from [ProjectsT] as well as a [Date Modified].

I have a Query where I am summarizing details from a project and just want to return the latest note [NoteText] for each project. How ?

	Kevin Robertson @Reply 12 months ago
You need to use 2 Queries. First Query should be an Aggregate Query Second Query should be joined on the dates (see screenshot below).

	Kevin Robertson @Reply 12 months ago

	Juan Rivera @Reply 12 months ago
Does Richard have a video showing this? this looks like a good quick one for the Lego box...

	Jeffrey Kraft @Reply 12 months ago
Juan He has done this a few times where he reminds you (beginner dude) that you may need to take multiple steps (queries) to get the query results you really want. BeginnerDude = Me.GoofballthatRespondedtothePost

	Kevin Robertson @Reply 12 months ago
Remember the above example will return a non-updateable recordset. If you need to be able to edit the records or add new ones use either of the examples below. The preferred method is the sub query.

	Kevin Robertson @Reply 12 months ago

	Jeffrey Kraft @Reply 12 months ago
And yes there is a video on subqueries....

	Juan Rivera @Reply 12 months ago
Jeffrey Yup just trying to keep up with all the videos sometimes I forget what all is out there.

	Alex Hedley @Reply 12 months ago
Subquery

	Chris Pardy OP @Reply 12 months ago
Kevin Thanks Very Much.. Works perfectly.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View