Unassigned data showing on REPORTS

[Guest]

When I create REPORTS pulling data for a certain field, the unassigned data
doesn't print on the report.

For example, I have a Household Inventory database and I created a REPORT
that lists the inventory by BENEFICIARY. If there are items in inventory
that are not assigned to one of the drop down selections (meaning the field
for BENEFICIARY is left blank) then these records don't show on the report.

How do I have these items/records show on the report?

 

[Duane Hookom]

Normally your report would be based on a query of one or more tables. In
this case you should have at least two tables in the report record source.
You can double-click the join line between the tables and select the option
to select all records from one of the tables.

If you can't figure this out, come back with the sql view of your report's
record source.