Filters - Either WIPBIlled or WIPWrittenOut has a value
Hi I was wondering if you could add a Filter/Where that involved two items from a database not just one, at present my report is bringing everything through and I only want it to bring through the records that have values in either WIPBilled or WIPWrittenOut in a given month. The only snag being sometimes the WIPBilled can be 0 and WIPWrittenOut can have a value minus or positive and vice versa WIPWrittenOut can be blank but WIPBilled will have a value, I could do with only these coming through on the report but at the moment it is bring through every client in the database even if they havent got a value in either of the two items above. I was looking to somehow merging the below filters with an OR if that makes sense so only bring through records which have a value in either of the below? AND Practice.ibvFeesAndWIPTotalsWithCats.WIPBilled != 0 AND Practice.ibvFeesAndWIPTotalsWithCats.WIPWrittenOut != 0 Hope this makes sense! Cheers Chris
June 15th, 2011 5:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics