I have a form that comments can be entered into and receive a time stamp.
So
I end up with multiple comments per project number. I want to run a query
that only returns the newest comment. Below is what I tried, but it is
only
returning the most new comment and not the newest comment by project
number.
SELECT Data_ProjectComments.Project_Number,
Data_ProjectComments.CurrentTime, Data_ProjectComments.CommentCode,
Data_ProjectComments.Comment
FROM Data_ProjectComments
WHERE (((Data_ProjectComments.CurrentTime)=(SELECT MAX(CurrentTime) FROM
Data_ProjectComments)));