My crews check out tools and return them. Every time they check out or return a tool, they create a new record. So...the tool is either incoming or outgoing. The problem arises when the check in/out process is bypassed and the tool is checked out when it was already out. I then have two records that are Outgoing. I have converted the incoming to a (-1) and the outgoing to (1). In a perfect world, this has allowed me to summarize wither it is out or in based on the sum of a 1 or 0 value. When they don't break the process and don't check it in or out in order, I then have a value of 2 or 3 or even -2 which messes up the sum report. Bottom line...I need to be able to accurately get a report that looks at the last entered record and tells me if it is "in" or "out." I just can't seem to find a way to properly summarize.