Access 2000 Inventory Problem

[Guest]

I have a table of logged data that contains tooling numbers, copy #of that
tooling number, Incoming/Outgoing option box, and a log date. I am trying to
build a query that dubs as a inventory list by looking at my table data and
giving me inventory by "Grouping" Tooling number and copy number together
(because some tools have multiple copy numbers), looking at the "Max" log
date (for the last time it was logged) of that tooling/copy group and seing
if it was incoming on that "Max" date and outputing that line of date. My
problem is I keep seeing some date that is right on and other times it is
giving me the last log date but listing it as incoming when it was actually
outgoing that day on my main table.

 

[Guest]

I figured out that Access in generating a "Record Number" field and is
going off of that record number for the latest entry. The problem is that
some entrys are corrected or added later with the right date but the
corrected earlier date might have a higher record number than a previously
outgoing tool record number. Can I just delete the record number field?