Printing most recent date???

[gaassist]

Hi everyone,

I created this database that allows me to track where a certain item has moved to and on what date. Therefore, there are many date fields for a specific item. What I want to do is print out the item, where it is, and the most recent move it made. Does anyone know how to do this? I don't want all the dates and places it has been to, just the most recent. Thanks.

[TerenceM]

You should have this set up with two tables, Items and MoveDates, so that you can pull up all MoveDates for a given Item with a relationship between the two tables (Items::ItemID = MoveDates::ItemID). Sort the MoveDates side of this relationship by Date (decending), and the first record pulled up will be the most recent MoveDate.

You should avoid creating multiple date fields in the Items table (or a repeating field), because there's no easy way to get data out of them.

-terence