If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Attendance database
I want to create a table to store student name, ID#, birthday, and all dates
that the student attended. If the student ID# is the primary key, how do I do this ?Eventually in a form and a report I'd like to pull up "last date attended" to see the most recent time the student was in class. Thank you |
#2
|
|||
|
|||
Attendance database
You need at least two tables to do this properly.
Table: Students StudentID LastName FirstName DOB Table: Attendance StudentID AttendanceDate I'm guessing you have something more like Table: IncorrectTable StudentID LastName FirstName DOB Attendance With that structure. SELECT StudentID, LastName, FirstName, DOB, Max(Attendance) as LastAttended FROM IncorrectTable GROUP BY StudentID, LastName, FirstName, DOB If you are doing this in the query grid. -- Add all the fields you want to see -- Select View: Totals from the menu -- Change "Group By" to "Max" under the field where you record the attended date. "mikebach" wrote in message ... I want to create a table to store student name, ID#, birthday, and all dates that the student attended. If the student ID# is the primary key, how do I do this ?Eventually in a form and a report I'd like to pull up "last date attended" to see the most recent time the student was in class. Thank you |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Access can't open database | Scott B | General Discussion | 1 | June 28th, 2005 04:16 PM |
Converting 97 database to 2003 database and implications | John | Database Design | 1 | November 22nd, 2004 05:23 AM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |