Query to not show empty fields

[trussman]

I am attempting to create a query that only gives the results of the fields with data. I have tried the >1 and "True" in the criteria. I either get everything or nothing. Basically I want to get it the point when I am ready to design the report it will only print out the fields containing the data. If there is a zero or empty field I do not want this printed. I hope I explained this correctly. I know this is simple, but for some reason it is not coming to me.

Thanks for any help.

 

[Lilliabeth]

I'm not sure I understand, but will take a shot:
<>0 And Is Not Null

 

[trussman]

Thanks I will try it.

 

[Golom]

I'm a bit fuzzy about what you are really asking. Do you not want to see individual fields that are empty or do you not want to see whole records that contain no data in certain fields?

When you mention "criteria" I assume that you are referring to the WHERE clause in an SQL statement and that includes (or excludes) whole records ... not individual fields.

 

[trussman]

I would only like to see the entries that contain data. If there is no data, I do not want to see them. Basically I am creating an order database. The report will be faxed to our supplier indicating what we want. I do not want the report showing excess data that does not pertain to the order and causing confusion.