I have a query that finds all the records in the 'projects' table equal to a date.
The 'projects' table has a related table called 'engineering notes'.
Is it possible to have the query display the last engineering note for each project that meets the criteria?
For example, when I run the query to find all the projects started this month, the query returns the same record for each engineering note and then carries on to the next project. All I want is a list of the projects plus the last engineering note so I can see at a glance the projects started and the latest engineering note for that project.