Condition Tracking Query

[Korski]

.....some quick background: This is a database for tracking the loaning out
of tools to various departments in the company. Each time a tool is loaned
out, it's condition is recorded before loaning out. There is no receiving of
tools back in....just loaning out. When a tool become too used to loan out
it is removed from the queue and replaced. This database is mainly used to
evaluate the conditions of the inventory of tools.

We have a table that has autonumber, ToolID, Date, Time,
Tool_Condition_Rating, loaned_to_Dept

-A record is added for each time a Tool is loaned out to a department
-The tool condition is determined at the time of loaning out.

-We'd like to have a query display a list of all records where the
"Tool_Condition" dropped from 4 to 3 or 3 to 2 etc. ....and what department
the tool was loaned out to just before the drop.

....any ideas greatly appreciated ! Thanks All.

 

[Fred]

As implied in your post I pres that each tool is handled as an individual.

I think that your main table should be:

A tool table (PK = ToolID)
A table wih a record for each instance of a tool being loaned out. FK
=TooID