Hi Experts
I have a table tblNote with the following fields:
I need a select query that will retrieve the record with furthest date group by TaskID. The query must include the the Note field. Heres my starting point.
This doesn't work because i know i also need to group by Note. Can anyone point me in the right direction.
I have a table tblNote with the following fields:
- NoteID
- TaskID
- ReminderDate
- Note
I need a select query that will retrieve the record with furthest date group by TaskID. The query must include the the Note field. Heres my starting point.
Code:
SELECT TaskID, MAX(ReminderDate), Note FROM tblNote Group By TaskID
This doesn't work because i know i also need to group by Note. Can anyone point me in the right direction.