I have a report that pulls data via query from a jobs table. I have a sub report in that report that pulls the notes of that job (different table for notes) and is linked Via the Job Number. There is a relationship setup between the tables one to many Jobs > Job Notes.



My problem is the report adds in another instance of a job for each note entry it has. So I see:

Job#
Note1
Note2
Note3
Job#
Note1
Note2
Note3
Job#
Note1
Note2
Note3
I want to only see the Job once with all the notes.

After I fix that issue I want to cut out most of the notes and only show the most recent note (there is a date field to filter by) but I can't seem to fine the syntax to only show the most recent note by date.

Any and all help Greatly appreciated.

Thank you,

John