• Tracking

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Tracking

    Author
    Topic
    WSbuckshot
    AskWoody Lounger
    November 30, 2009 at 12:19 pm #464178

    How in a Access can you track people or something not only by the group but by individually is there a sample out there. Example if you had 100 5th graders and they all went to Washington for studies–I know how to get a report,quary for the group and my query or report would have 100 students gone and 0 at school. Now lets say only Mary and Tim from the 5th grade went–How would you track them 2 only and have the query or report say 98 students left?
    I have a student table that list the names and a group table that list the classes by groups they are linked. Maybe the whole database needs to be set up different? Anyone have a example of a database that will track by group and by each?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSAndrewKKWalker
      AskWoody Lounger
      November 30, 2009 at 12:48 pm #1187248

      How in a Access can you track people or something not only by the group but by individually is there a sample out there. Example if you had 100 5th graders and they all went to Washington for studies–I know how to get a report,quary for the group and my query or report would have 100 students gone and 0 at school. Now lets say only Mary and Tim from the 5th grade went–How would you track them 2 only and have the query or report say 98 students left?
      I have a student table that list the names and a group table that list the classes by groups they are linked. Maybe the whole database needs to be set up different? Anyone have a example of a database that will track by group and by each?

      Without knowing table names and fields I cannot be specific.

      However assuming if students in a table called Students, and Visits in a table called Visits.
      Then you will need an Outer Join query between Students table and Visits table, with appropriate filters on both sides,
      so that your query will extract ALL students along with relevant Visit details for those that went.
      From this you can then build conditional stats counting how many went, how many stayed etc.

      That is a hint in correct direction but that is all that can be offered without specific details.

      Reply | Quote
    Viewing 0 reply threads
    Reply To: Tracking

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.