I am fairly new to Access so please bare with me. I have a database of our shipping information and need to calculate the average process time of shipments. The data table with the information I need is just a running collection of processes (not my design), so incoming is one line and outgoing is a different line etc and for everything that has been processed. I have figured the best approach is create 2 queries, one looking for the in coming and changing the system date to Time In, and the other with the outgoing to Time Out. Then I have a third query that takes the information so Time In and Time Out can be on the same row with a new column to calculate the difference. The issue I am having is that I have a few items that have come through multiple times and the query seems to be listing every combination. For example I have an item that has been here twice (2 separate dates in TimeIn query and TimeOut query), but the final query has 4 instances (first time in with both time outs and the second in with both outs). I tried using DISTINCT in SQL for all 3 queries, but that doesn't help. Can anyone help?