Pull off blank records??

[slyvsspy]

When running a query. What value do I use in the "criteria' box to pull off every record. I have to have something in the criteria box, I can't just delete it, so I have to have a statement in the criteria box that will pull all records.

Does anyone know what this statement will be.

Thanks for all the help
Josh

 

[Sohaila Taravati]

In your query put "Is Not Null" and it will show all the fields that are not empty