Report Help on Empty Records (Access)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • puT3
    New Member
    • Jul 2008
    • 145

    #1

    Report Help on Empty Records (Access)

    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
  • puppydogbuddy
    Recognized Expert Top Contributor
    • May 2007
    • 1923

    #2
    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.

    Comment

    • puT3
      New Member
      • Jul 2008
      • 145

      #3
      Originally posted by puppydogbuddy
      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...

      Comment

      Working...