Results 1 to 2 of 2
2009-11-30, 12:19 #1
- Join Date
- Dec 2002
- 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?
2009-11-30, 12:48 #2
- Join Date
- Apr 2001
- Cambridge, UK
- Thanked 3 Times in 3 Posts
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