Hi,

I'm trying to create a report from a database where I have different items and their locations (selected by radio buttons), there can be many entries for each item as they are located in different places at different times. What I need is to take the newest date entry for each item and use that to create a report that tells me how many of each item is in each location at any time I choose to view the report.

Hope this make sense.

Thanks

lsimpson

You'll need a self-relationship from item id to item id, sorted by date descending, and a calculation number field of serial = selfrelationship::serial. This calculation will return a 1 for the most recent record for each item and a zero for all previous ones. Doing a find for 1 in this field will then give you the records for your report. Note that the calculation will take longer the more related records there are in the file. It would probably be a good idea to archive records that are a year or two years old, depending on how many records one item will have per year on average.