Show all records even if data is missing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a list of competitors in an event, some of whom belong
to teams, others don't. I'd like to show all the competitors, regardless of
whether or not they belong to a team, but when I include the team field on
the report, it only shows competitors who belong to a team. How can I show
everyone?
 
Open your query used as record source for the report in design view. Double
click on the line connecting the team table to the competitors table. Select
the option to show all from the competitiors table and those that match from
the team table.
 
Thank you.

KARL DEWEY said:
Open your query used as record source for the report in design view. Double
click on the line connecting the team table to the competitors table. Select
the option to show all from the competitiors table and those that match from
the team table.
Click to expand...
 
Back
Top