I would have to include an expression in my query correct? How might I go about this expression to actual hide the data on my report... This wouldn't actually hid my occurance of the Headings and space such field takes up on my report correct?
where a field would go in the query grid, you would put something like this instead:
MyFieldName: IIf([MyFieldName]<=0, "", [MyFieldName])
What this does is says, if MyFieldName is less than or equal to 0, then put a string of zero length into the query, otherwise put the data itself into the query.
Of course you will need to put your own field name(s) into the statement where MyFieldName currently is.
I guess it's not possible to have the detail and header for a field on a report not be included if value is <=0 ... by using the query expression the report will still keep any headers and the space that the detail occupies in the report.. the visible property would have to be set to No manually for each filed I desire to be exclusive from the report!
I guess I missed that part of the request. I sounds like you are trying to either not show the entire detail line if one or more fields are <= zero. And I guess if a whole group of detail records add up to <= zero, then you want the whole group to not show on the report? Because both of these things are possible in Access to accomplish. Just let us know which, or both you want.