I have a database with the folowing fields
NAME (Text)
ITEM (Text)
DESCRIPTION (Text)
QUANTITY (Number)
IN-OUT (Combo Box "IN" or "OUT")
DATE (Date / Time)
LOG_BY (Text)
This is basically a log to keep track of items logged in and out of a secure zone. I want to create a query that will show the items still in the secure zone. So the query will somehow have to reconsile the items IN and the items OUT. Problem is, I don't have a clue how to do this. Then I will ultimatly build a report based on the query.
I appreciate any help.
Jim
NAME (Text)
ITEM (Text)
DESCRIPTION (Text)
QUANTITY (Number)
IN-OUT (Combo Box "IN" or "OUT")
DATE (Date / Time)
LOG_BY (Text)
This is basically a log to keep track of items logged in and out of a secure zone. I want to create a query that will show the items still in the secure zone. So the query will somehow have to reconsile the items IN and the items OUT. Problem is, I don't have a clue how to do this. Then I will ultimatly build a report based on the query.
I appreciate any help.
Jim
