Display only the field with value

[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..

 

[Duane Hookom]

You open the report's record source in design view (query design) as set the
criteria under a field/column to:
Is Not Null

 

[EMILYTAN via AccessMonster.com]

Thanks a for helping...

You open the report's record source in design view (query design) as set the
criteria under a field/column to:
Is Not Null