Newbies mbachman Posted November 1, 2002 Newbies Share Posted November 1, 2002 I need to track students' attendance at workshops. So, I have a Students file, a Workshops file, and a join file named Workshop_Enrollment. However, I need to make sure I have the specific date of the workshop and whether or not a student was absent, present, tardy, or dismissed. I have students going to different workshops on the same date and the workshops are held on many dates. One of the items I will need to produce is a report identifying the name of the workshop with the list of students attending that workshop and if they were absent on each day the workshop was held. I am not exactly sure how set up the files in order to produce this report. Help is greatly appreciated! Link to comment Share on other sites More sharing options...
Kurt Knippel Posted November 1, 2002 Share Posted November 1, 2002 Student file contains the student information (i.e. StudentName), Workshop contains the workshop information (i.e. WorkshopDate) and Workshop_Enrollment contains the information unique to a particular student in a particular workshop(i.e. Status) and may also contain calculations to display related data from the Student and/or Workshop tables. Since you wanna display information from all three tables, you will most likely develope your reports in the Workshop_Enrollment db. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7981 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now