Results 1 to 2 of 2

Thread: Tracking

  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by buckshot View Post
    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.
    Andrew

Posting Permissions

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