Even there is no image in the field the record should be seen in the access report.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mb60
    New Member
    • Aug 2008
    • 37

    Even there is no image in the field the record should be seen in the access report.

    My database has fields Q, 1,2,3,4,YES/NO, image.
    The image field is meant for jpeg pictures. In the query, criteria has " IS NOT NULL" code.
    When I select the checkbox the entire record is displaying without any problems. If the 'image' field is empty the entire record is missing from the report.
    Even though there is no image in the field, if I select the record with checkbox option, the record should be seen in the report.

    .

    Thank you
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32661

    #2
    Confused as to why you would ask.

    Remove the criteria selecting the non-empty ones if you want all to show.

    Comment

    Working...