Hello,
I have a table for entering the status of a production batch with a DateStamp (Now() criteria) field, and a LotNumber field (which will contain multiple entries of the same lot). I want to run a query the returns only the latest entry for each lot. Any Ideas. I'm not good with VBA. I was trying to use the DMax function but getting errors.
Thanks, Nancy
I have a table for entering the status of a production batch with a DateStamp (Now() criteria) field, and a LotNumber field (which will contain multiple entries of the same lot). I want to run a query the returns only the latest entry for each lot. Any Ideas. I'm not good with VBA. I was trying to use the DMax function but getting errors.
Thanks, Nancy