Display only the field with value

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

I have the report to display only the record with value...May i know the way?
For example some record might not have value in certain field and I only want
to showed the one with value....
Thank you..
 
You open the report's record source in design view (query design) as set the
criteria under a field/column to:
Is Not Null
 
Thanks a for helping...

Duane said:
You open the report's record source in design view (query design) as set the
criteria under a field/column to:
Is Not Null
Click to expand...
 
Back
Top