Reports

F

Fay

I need to create a report to show who have and who have not take a class. The
have part I got. What I want is a listing of everyone from a department and
then a column that reports the date attended or blank if they haven't
attended. But I am not getting it done. I think it is a join issue, but I am
not sure. I have tblLearners, tbllearnersDepartment, tblRegistration,
tblSession, and tblClasses.

Thank you.
 
J

Jeff C

I would create the report template laying out the information I wanted and
then in the control source for the report(upper left corner in design mode
and double click) I would enter an expression to filter the data I wanted.
 
J

John Vinson

I need to create a report to show who have and who have not take a class. The
have part I got. What I want is a listing of everyone from a department and
then a column that reports the date attended or blank if they haven't
attended. But I am not getting it done. I think it is a join issue, but I am
not sure. I have tblLearners, tbllearnersDepartment, tblRegistration,
tblSession, and tblClasses.

Thank you.
Click to expand...

I presume you need a Left Join: try joining tblLearners to tblSession;
select that join line and choose option 2 - "Show all records in
tblLearners and matching records in tblSession". The session date
field will show the date if they attended, and NULL if they didn't.
Apply other tables and criteria as needed.

John W. Vinson[MVP]
 
J

Jola

U¿ytkownik "Fay said:
I need to create a report to show who have and who have not take a class. The
have part I got. What I want is a listing of everyone from a department and
then a column that reports the date attended or blank if they haven't
attended. But I am not getting it done. I think it is a join issue, but I am
not sure. I have tblLearners, tbllearnersDepartment, tblRegistration,
tblSession, and tblClasses.

Thank you.
Click to expand...
 
Top