How can I sort out blank rows

[Tumoz]

I use Access to declare what information can be found in our database with the desired criteria.
The problem comes when I want to filter, for example, just fields what contains the mailing address information.

For example i have 10 rows of information and only 4 of them contains mailing address.
How can i ask Access to show me just these mailing address rows? (I want to know what other information can be found also on them?)


I've tried using "Is not null" command in Mailing address field, but that does not seem to be working.

Please help me

 

[Pretty1996]

Hi

Have you tried using

<>""

in the query criteria for the field.

 

[Tumoz]

Hi

Have you tried using

<>""

in the query criteria for the field.

Yes, this works!
Thousands of thanks my friend!