Thank you for clicking and any help you can offer.
I am still a beginner and I am learning the hard way due to not having much if any documentation for Access 2000. (by trying to adapt tutorials and lessons to the older version.)
This is Access 2000 and I cannot upgrade.
Maybe I am misunderstanding how Unique records works.
I have an Autonum field, a Lot Number, and some chemistry make up fields (eg: C, Mn, P, S).
Everything is set to short text type because sometimes letters are used.
Each lot number has a designated make up of chemistry so for example Lot 1 will always be C: 5, Mn: 8, P: 6, S: 10. It will never change.
The problem is that for almost 10 years people have been manually entering them so I am trying to write a query to find all unique records/mistyped records.
For Instance say this is our table
Autonum: 1 Autonum: 2 Autonum: 3
Lot: 1 Lot: 1 Lot: 1
C: 5 C: 5 C: 55
Mn: 8 Mn: 8 Mn: 8
P: 6 P: 6 P: 6
S: 10 S: 10 S: 10
Lot 1 was used several times but it looks like someone accidentally hit the 5 key twice.
I want a query that would ignore the autonum field. So it would show me only Autonum 1 or 2 (since they are the same) and Autonum 3.
That way I can give this list to one of the people who enters them and they can tell which Autonum is wrong and go edit it.
Unfortunately the person who made this database before me put all this information in one table instead of linking the Lot to each Autonum.
Before someone says just run it without including the Autonum field, Yes that would work but we use Autonum as our ID system so while I could see what lot is wrong I would have to sort through hundreds of Autonums with that Lot number since they are contained in the same table. So I somehow need to know which Autonum has the messed up Lot information.
Currently I am trying to use the Unique Records option but it thinks every record is unique due to the Autonum field. Its an odd problem I know.
So that brings us to my title, Is there a way to make Unique Records ignore the Autonum field while still having it show?