Records from 2 tables

[lipin]

I have a table where audit info is stored. If something is found incoorect in a shipment, it needs to go back to inventory. Well, we log eveything and management would like to track how long it takes to get back to stock. Well, the return to stock is kept in Excel. So I import the log into a table so I might be able to compare it to the audit table where there is a date field to say when the excess was found.

How would I compare the two tables to determine how long it took to go back to inventory? What type of query(ies) do I need?

the fields (With sample info) in the excel sheet are

Product Code: 40561-6102
Size: 34
Units:1
Location:22-22-G-2
Date:3/13/03

None of these are primary keys as they can all have dups.
All of these fields(+ more) also exist in the Audit Table.

Was trying unmatched but you can have multiple of same product code returned to stock in one day.

I think I need to sum units by product code and say something like 24 units found on this day and 22 returned on this day.

How would I do this?

 

[Fornatian]

Does the product code and size form a composite primary key? If so and it exists in both tables, you could do as you suggest and do a sum query to collate duplicates then create links between product code and size in both tables to allow the info to included in one dataset. I think.