I am in control of a small group of resources (laptops, projectors, etc) and I want to keep track of these with history in Access. We were using an excel spreadsheet but this provides no history. We do not need to keep up with borrowers in a seperate table. To know it was borrowed and a field somewhere (depending on the design) giving the name of the borrower would be sufficient.
I have two designs in mind:
- 10 tables, 1 for each resource, and a query to pull the last item from each table Problem: Seems a bit stupid. Also a tough query.
-2 tables, 1 for the resources and specifics and 1 as a transaction table for each check in/out. Problem: Seems to be a better or at least more traditional design but how do I show what is available? How do I summarize where each resource is?
I have scoured the internet for another like-minded example but to no avail.
Any suggestions on example file or design would be most welcome.
That's what I was leaning toward. Q: How can I pull the last of each item from the list of transactions(in/out) to give me a summary list of condition on each resource? (Laptop 1 IN , Laptop 2 OUT , etc)
I am confused on how to use the max function or the last function. Could someone take a look at the query and tell me how to get the last of each item borrowed so I can make a list of each resource and where it currently is? I have included the files.