Confusing report structure

  • Thread starter Thread starter Richardson
  • Start date Start date
R

Richardson

I have a strange situation in my database and I am not sure how to make it
print out in a report.
Table 1, "Members" has member names and information with MemberId as the
key.
Table 2, "Programs" has programs that members are registered to take and
joins to Members through the MemberID.
i.e.
Members
MemberID
MemberName
etc.

Programs
Registration#
MemberID
Date
Prgram Type

Now I need a report to look at 3 program types per member that will resemble
the following so that we can quickly see which programs the members are
missing. I need to see all members and only checks, or some other mark, for
the programs in which they are registered.
Member Name Health Education Chemistry
Biology
Mickey Mouse x
x
Minnie Mouse
x
Donald Duck x
x x


I appreciate any help you can provide.

Lori
 
Create a crosstab query that uses:
MemberID as Row Heading (group by)
MemberName as Row Heading (group by)
Program as Column Heading
RegistrationID as Value (Count)

In the properties of the query, use the Column Heads property to list the 3
programs you want in the query.
 
This looks like a crosstab would work. The Member information would be the
row heading. The column heading would be the Program Type. You could
Count(Registration#) as the value.
 
Back
Top