Report not showing blank records

[ExcelDummie]

I have noticed that on my report where the organisation field has no entry it
doesnt show that record how do i fix this>?

 

[Duane Hookom]

First check your report's record source to see if the records appear there.

 

[ExcelDummie]

the records exist it is just that the if the organisation field is blank the
record does not appear on the report

 

[Duane Hookom]

I didn't ask if the records exist. I wanted you to open the report's record
source in datasheet view to confirm the records are there. While viewing,
check the record count of the datasheet. Then, when in design view of your
report, check the filter property to make sure it is empty. Then add a
control to your Report Header Section with a control source of:
=Count(*)
Does this text box display the same number as you saw in the record count of
the datasheet view?