Report most recent entry to report per Line

[kdoran]

Hi,

I have a couple of tables

tblFieldTag
FieldTagId
Input
Span
Out
Description
ProblemLoop (Yes/No)

tblFieldTagNotes
FieldTagNotesID (number)
FieldTagID
FieldNotesDate
FieldNotesText

What I am trying to do is have a report that will pull the ProblemLoops up with the info from tblFieldTag (this I am not having problems doing) and the latest entry from the TblFieldTagNotes which would be the FieldNotesDate and the FieldNotesText. When I try this I get all the entry notes for a FieldTag. I have also tried a to make a seperate query and use that in the current query that would show TOP 1 but that caused only the latest entry for a single FieldTag to show and not the rest.

Thank you in advance,

Kelly

 

[LNBruno]

I ran into a similar situation and ended up with the separate query you mention.

You might try something like this:

SELECT MAX(FieldNotesDate), FieldNotesText
FROM tblFieldTagNotes

along with any WHERE clause you deem appropriate.

HTH!

< M!ke >