Report Only most current Reassign

[Lance A. via AccessMonster.com]

I have a table that keeps the activity assignments for each record that is
reassigned to another group. I need to produce a report that shows only the
most current reassigned to group only. I have a date and timestamp field on
each record, but do not know how to capture just the most current in a query
or a report.

Can anyone help me with the code to do this??

Thanks,
Lance

 

[Allen Browne]

If you just want to know the most recent date for each record, you could:
1. Create a query into both tables.

2. Depress the Total button on the toolbar (upper sigma icon.)
Access adds a Total row to the grid.

3. In the Total row under the fields from your main table, choose Group By.

4. In the Total row under your ActivityDate field, choose Max.

If you want more than just the latest date (other info about the latest
activity), see:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm