Designing Tables to track issues

[JjJSeVdT]

Good Morning all, I hope someone can help me out. I'm making a database to help me keep track of some machines I do repairs on and issue out to coworkers. I've attached what I have for reference so might be able to assist easier.

What I'm trying to do:
I want to keep track of an on going list of machines that get signed out. I was thinking about a Yes/no field on the machine table to denote if it was gone, but I want an ongoing record. I have a separate table to list Issues. When I go to edit a machine's status I want it to ignore any status except the most recent.

So if machine "12345" has been signed in and out 3 times and I query all machines signed out, I don't want a query to show

12345 - 2 Jan
12345 - 7 Jan

when infact the machine was signed back in the next day. I'm trying to use the data in the table to do the queries. Please take a look at the attachment and give me some advice. I've made databases before, but that was a few years ago and I've forgotten alot. Thank you

[aytee111]

Have you tried the Totals button in your query, using Min/Max and First/Last for getting the latest date?

Or maybe you can add some more data to your database, there didn't seem to be the scenario you were talking about, or if there is let me know the machine ID.