Printing Empty/Blank Records

[Guest]

I hope someone can help me please

I set up a report from two tables - "Staff Table" contains details of all staff within the company. "Courses Table" contains staff names plus all courses they have completed

Each table contains staff's first name and surname in two separate fields. I have linked these tables using these two fields in order to create a form and a subform

I have now created a report with all this information on. However, the report only shows those staff who have completed courses, and not those who have not yet completed a course

I want the report to show ALL staff and the courses they have completed (if any). Therefore, how do I get the report to also show staff who have no data in the Course Completed field

Many thanks for any help

Jen

 

[Allen Browne]

In query design, double-click the line joining your Staff Table to your
Course Completed table.

Access opens a dialog that gives you 3 options.

Choose the one that says:
All records from Staff Table, and any matches from ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I hope someone can help me please!

I set up a report from two tables - "Staff Table" contains details of all

staff within the company. "Courses Table" contains staff names plus all
courses they have completed.

Each table contains staff's first name and surname in two separate fields.

I have linked these tables using these two fields in order to create a form
and a subform.

I have now created a report with all this information on. However, the

report only shows those staff who have completed courses, and not those who
have not yet completed a course.

I want the report to show ALL staff and the courses they have completed

(if any). Therefore, how do I get the report to also show staff who have no
data in the Course Completed field?