MS Access report last 2 status entries?

Question

I have a DB with projects that captures status entries in a memo field and the status date. I would like to create a report that shows the last 2 status entries per project. Is this doable?

Thanks

Arthur

how can i do this?

Answer 1

Absolutely....

Since you are capturing the date/time of the status entries all you need is a query. The query will sort the records by the status Date in a decending order and include records which have data in the memo. A decending sort will put the most recent dates at the top of the results. To get the most recent two records you will modify the SELECT query with TOP 2



SELECT TOP 2 Table1.*
FROM Table1
WHERE (((Table1.memo)<>""))
ORDER BY Table1.date DESC;