Getting what I want in a report from my query

[commanderrico]

Ok, I have many fields in a table and I want to create a query based on that table. There are some fields that don't have any information in them at all. In my query I want to design so that all the fields are listed in case they are added to at some other point in time but if there isn't anything currently in them I don't want them to show up when I run the query. Does that make sense? This way when I create my report based on the query it won't contain a bunch of empty spaces where there is no information. Can someone please help? If you have questions just ask. thanks for your help

rico

 

[LarryDeLaruelle]

in the criteria cell of the field where you want only data returned, enter Is Not Null.

Unfortunately, the result will be that any record that has a null (empty) value in that field will not be in your result.

If that is OK then this will do it for you.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org