Alright, I have a complicated question for you all... Any help would be greatly appreciated, and I’m hoping there are enough capable people on this forum to tackle a problem that isn't necessarily difficult, just incredibly confusing..
Here is the situation: I am building a database in Access—specifically, I am working on a Query. It is a database for tracking the issuance of certain area cards (the specifics don't matter right now, but just imagine the RELATIONSHIPS are like CATEGORIES > BOOKS in a library)
So, I have one table that looks like this:
ID is an autonumber. Category is a relational field linked to another table containing the full list of those "books." Last Name is also a relational field from a second table containing everyone who borrows these "books." The checkout/return dates are fields in this table, which I assume you all understand the purpose of.. 🙂
Essentially, this table records every single instance of these Categories being checked out and returned.
Now, here is what I actually want to achieve:
I want to create a query that outputs all categories that have been returned! However, I do not want a category that was returned twice (for example, category 10) to show up twice in my results. I only want it to display the record from when it was last returned. Specifically, I want the record with ID number 18 to be displayed, while ID17 should be completely excluded!
To be clear, I want the red fields shown in image2 Query NOT to appear:
Records with IDs 17, 19, 21, and 24 should not be shown because more recent records exist for those specific categories. Additionally, the record for ID20 should be excluded because it hasn't even been returned yet.
The final result produced by my Query should look exactly like this:
Does anyone have any ideas on how to solve this? If you need further details, just ask...
Thanks much!
Here is the situation: I am building a database in Access—specifically, I am working on a Query. It is a database for tracking the issuance of certain area cards (the specifics don't matter right now, but just imagine the RELATIONSHIPS are like CATEGORIES > BOOKS in a library)
So, I have one table that looks like this:
ID is an autonumber. Category is a relational field linked to another table containing the full list of those "books." Last Name is also a relational field from a second table containing everyone who borrows these "books." The checkout/return dates are fields in this table, which I assume you all understand the purpose of.. 🙂
Essentially, this table records every single instance of these Categories being checked out and returned.
Now, here is what I actually want to achieve:
I want to create a query that outputs all categories that have been returned! However, I do not want a category that was returned twice (for example, category 10) to show up twice in my results. I only want it to display the record from when it was last returned. Specifically, I want the record with ID number 18 to be displayed, while ID17 should be completely excluded!
To be clear, I want the red fields shown in image2 Query NOT to appear:
Records with IDs 17, 19, 21, and 24 should not be shown because more recent records exist for those specific categories. Additionally, the record for ID20 should be excluded because it hasn't even been returned yet.
The final result produced by my Query should look exactly like this:
Does anyone have any ideas on how to solve this? If you need further details, just ask...
Thanks much!