G
Guest
I have noticed that on my report where the organisation field has no entry it
doesnt show that record how do i fix this>?
doesnt show that record how do i fix this>?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
First check your report's record source to see if the records appear there.
G
Guest
the records exist it is just that the if the organisation field is blank the
record does not appear on the report
record does not appear on the report
D
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?
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?
- Joined
- Sep 20, 2006
- Messages
- 3
- Reaction score
- 0
If it has no entry try NZ([field_name],0)
All the fields which have no organisation field will then have a 0 in it, note the 0 can be replaced with anything you like.
All the fields which have no organisation field will then have a 0 in it, note the 0 can be replaced with anything you like.