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.