Sort last note for each contact

[richo]

I have created a database that has a notes section which we enter each time contact is made with also a follow up date against it. For instance the field names l have is date, note, follow up date and a check box for complete. So l may enter a note 12/12/01 called steve and he wasn,t in follow up date entered 15/12/01. This would then be ticked when completed.

I need to be able to run a query and only produce the last note for each company. Now some companies last note is complete so it is ticked while others aren't. Is it something to do with the duplicates?

Thanks in advance

Richo

 

[THoey]

Would this work:

SELECT MyDate, MyNote, MyCheckbox, MAX(MyDate)
FROM MyTable
GROUP BY MyDate, MyNote, MyCheckbox Terry M. Hoey