OK, I have a table with a column for holding some numbers. sometimes there is a 0 entered in the field and sometimes no info, otherwise numbers. I want to count, sum and average all the records where there is a non-zero value. if i set up a query to this field and set to <>0 then i get a list of all the records with some non-zero data. fine. BUT, when i set the query to Count it insists on picking up the 0 records even with the criteria set as above. ?? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
BTW, I am working on finalizing this project for production and prefer to have a default of 0 for this and some other fields rather than a mix of values, 0s and nulls. therefore, i need to find out why Count is in love with records with 0 as a value.
<font color=448800>FIXED IT. Turns out I needed to run one query with the criteria set and then load that info into another query to execute the count, sum and average. guess i was asking too much from SQL to do all that in one go.</font color=448800>