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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report advice please 1
Hyperlinking Report Data to a Form Record 2
Group Footer in a report 1
Need to count duplicate field entries only once not total 1
Columned Access Reports 1
Help Pls - 1 Combo box and 1 Date Field on a form to create a repo 2
Total competitors points 3
Design of Tables 2

Back
Top