last record added query

[boopers]

I need help in how to only show the last record that meets criteria.
I have a transactional table that houses all activity that occurs for our I/S work orders. I am pulling the w.o#, sequence, date/time and person assigned from one table. I only want to see the last record (either by sequence or date) that is associated with a w.o. But I still need to then see that detail for that last occuring record. I have tried grouping, summarizing, writing a formula, and just can't seem to get it right. I used the TOPN sort after summarizing, but I can't get the other fields then that go with that record. HELP!

 

[synapsevampire]

What does "but I can't get the other fields then that go with that record" mean?

It's unlikely that you have field level security or that the entire row isn't being returned, perhaps you mean that you want the last row of each workorders data displayed, and then you want to drill in to all of the other records for this work order on demand?

If so, group by the WorkOrder, and place the fields you want to display in the group footer.

Right click the details and select hide (drill down ok)

Hide the Group header, and you should have the look that you want.

-k