Reports for every entry (empty or not)

[Styles2304]

I have a Roster table with a plethora of information in it. One field in particular is the Service Member field with the names of each soldier in my Platoon. I've created a separate table to store APFT data.



Now, when I print the report, I want it to display an entry from the APFT table for every entry in the Service Member field of the roster table whether there is data in the APFT table for the soldier or not. Blank fields are just as important as populated fields.

Is this possible?

[pbaldy]

I assume your report is based on a query. Edit the join between the two tables, choosing the appropriate option. That will change the join from INNER to LEFT or RIGHT as appropriate to your situation.

[Styles2304]

Well . . . that did it . . . thanks! That's pretty much exactly what I was looking for.

[pbaldy]

Happy to help, and welcome to the site by the way! I'll mark the thread solved, but post back if you need further help on this.