Make Table Query

[prabhu]

Hi,

In my make table query results, some of the fields are empty as they dont have any datas. while using this Make table Query results, i am not able to filter these fields, i tried Notlike " *" but its not working.

Some one suggest me to fix this...

 

[boblarson]

It would be

Is Not Null

 

[ghudson]

try...

Is Not Null

 

[prabhu]

thanks, but IS not null - not working

 

[boblarson]

thanks, but IS not null - not working

So, you need to give us more information. We can't read your mind, nor see your database. So, when you say "not working" what do you mean? Does it give an error? Does it still bring back records with those fields empty? Does it flare up into a great fireball and singe your eyebrows?