Hi Orlan,
Forget Dlookup for what you want.
Your Tables are not normalized because you have
repeating Fields so you can't use a regular Query.
However, you can get the results you want by creating
five Queries, one for each day in the student field
and using a UNION Query to concatenat the results.
In each of the five Queries have the Instructor Table
ClassNumber linked to the Student table by one of
the Mon-Fri Fields.
Then create a Union Query of the five new Queries.
You can do the Sorting and Grouping in the Report
Design.
Alternatively you could Normaliz the design. If you
want to do that, raise it as a new subject.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "ovj29" <orlanvj@...> wrote:
>
> 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 (2) |
Tidak ada komentar:
Posting Komentar