I have two tables I want to draw data from.
The first is a list of students with days Monday thru Saturday as fields. The field data on each is the class number from 01 to 24. The second table is a list of instructors with the class number.
I want to create a report for each instructor showing the students they have on each day. I tried starting with the instructor list and using Dlookup to bring in the students, but it will only show the first student, not the entire list.
Can anyone suggest a method of getting the listing I want? This database will be used for a local carving group's annual rally every year so I am not above redoing the entire database to make it work.
Orlan
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar