dolano 2nd cousin of Rincewind Local time Today, 10:11 Joined Jul 19, 2006 Messages 28 Jul 20, 2006 #1 Is there a way while using the count query to make it return zero when using the criteria (not like "N") instead of a blank datasheet.
Is there a way while using the count query to make it return zero when using the criteria (not like "N") instead of a blank datasheet.
B Banana split with a cherry atop. Local time Today, 02:11 Joined Sep 1, 2005 Messages 6,318 Jul 20, 2006 #2 Search on Nz function.
