Inventory - Field Comparison

  • Thread starter Thread starter ME
  • Start date Start date
M

ME

I developed an inventory database in Access 97 for storing
serial numbers, location, status, etc. for hardware. The
main table has data from 2 physical inventories. I
developed a duplicate query on equipment serial numbers,
which in effect gives me the data on equipment from both
inventories for location, status, etc.

To minimize the amount of data to review, I've been trying
to build another query (based on the one above) that lists
only those records from both inventories that differ in
location, status, etc. I've tried using the Unmatched
query wizard, but that did not give me the expected
results. Any help would be appreciated.

Thanks,
ME
 
This should work where ESN = Equipment Serial Number and Query2 is the query containing all the data

Select ESN, Location, Statu

from Query

where ESN In (Select ES
fro

(Select Distinct ESN, Location, Statu
From Query2) as Sub

Group by ES
Having Count(*) > 1

Regard
Rowan
 
Rowan,

Thanks very much, I'll give this a try.

Maryann
-----Original Message-----
This should work where ESN = Equipment Serial Number and
Click to expand...
Query2 is the query containing all the data:
 
Back
Top