G G1ZmO Registered User. Local time Today, 22:02 Joined May 4, 2006 Messages 133 Jun 25, 2010 #1 I have a field which contains a count "=Count([QTY Sold]) " Some of the fields have 0 as the data and it seems to include this value in the count. How do I stop it counting a 0 as a value? THanks Paul
I have a field which contains a count "=Count([QTY Sold]) " Some of the fields have 0 as the data and it seems to include this value in the count. How do I stop it counting a 0 as a value? THanks Paul
V vbaInet AWF VIP Local time Today, 22:02 Joined Jan 22, 2010 Messages 26,328 Jun 25, 2010 #2 Put in the criteria of each field: <> 0
G G1ZmO Registered User. Local time Today, 22:02 Joined May 4, 2006 Messages 133 Jun 25, 2010 #3 Sorry, not sure what you mean =Count([QTY Sold])<>0 doesnt work Where is the criteria property?
V vbaInet AWF VIP Local time Today, 22:02 Joined Jan 22, 2010 Messages 26,328 Jun 25, 2010 #4 Your report should be based on a query. If it's based on a table, then create a query based on that table and change the RECORD SOURCE property of your report to that new query. You set criteria in queries.
Your report should be based on a query. If it's based on a table, then create a query based on that table and change the RECORD SOURCE property of your report to that new query. You set criteria in queries.
