Results 1 to 6 of 6

Thread: Check IN/OUT

  1. #1
    Join Date
    Feb 2005
    Posts
    8

    Red face Unanswered: Check IN/OUT

    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.

  2. #2
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    I think 2 tables could be sufficient rom the description given.
    For Example

    tblEquip
    EquipID Equip_Desc
    1 Laptop1
    2 Laptop2
    3 Projector

    tblInOut
    TransID Type EquipID
    1 Out 1
    2 Out 2
    3 Out 3
    4 In 1

    EquipID is the PK on tblEquip tblInOut TransID is your PK and Equip is FK.
    Run your queries.
    Darasen

  3. #3
    Join Date
    Feb 2005
    Posts
    8

    Exclamation yep

    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)

    Any help appreciated.

  4. #4
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Max function.
    Darasen

  5. #5
    Join Date
    Feb 2005
    Posts
    8

    Thanks Darasen,

    I get it. Combine each resource with a MAX on the PK (autonumber). Thanks.

  6. #6
    Join Date
    Feb 2005
    Posts
    8

    Ok, I guess I don't get it

    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •