Can I Search for the Latest Date in a field
I need to create an aging Inventory report
Inventory - I need to search for an Item#, that has Qty on hand: (This is the part I don't know how to do) in the date field, I need to search for the last date entered, or newest Date..
When Inventory comes in it is entered by date
When I do a search for inventory on hand that was entered in 2009 it reports it, the problem is that if items were enter after that and is included in the inventory total it doesn't show that.
You can't search for it but you can sort for it. The "sort" that will most likely work for this situation is to use a relationship where you specify a sort order for the table that has this data sorts the records by date in descending order.