How can I make the report do not show any empty records? For example, in this [Company] table do not has address...I want the report only shows company that has address
Report Help on Empty Records (Access)
Collapse
X
-
The easiest way is to do it in the query that is the source for the report. Place the query in design view; go to the criteria row of the company column and put the following constraint:
Is Not Null
This will exclude rows where the company name.is null from being passed to the report. -
Ok,Thank you for your help...Originally posted by puppydogbuddyThe easiest way is to do it in the query that is the source for the report. Place the query in design view; go to the criteria row of the company column and put the following constraint:
Is Not Null
This will exclude rows where the company name.is null from being passed to the report.Comment
Comment