Greetings, I have a table with a number of Yes/No fields. I have a total of 655 records. For each field, I want to count the number of 'Yes' values. In my query (design mode), I chose the field and the count function. Somehow, the query is returning counts of way more records than I have. The numbers vary, depending on whether I set the criteria to "IS NOT NULL", which gets changed to "IS NOT EMPTY".
Here is the SQL statement: SELECT COUNT( "tbl_BizContact"."biz_id" ), AVG( "tbl_Survey2006"."biz_age" ), COUNT( "tbl_Survey2006"."foss_supt_biz" ), COUNT( "tbl_BizContact"."biz_name" ) FROM "tbl_BizContact" "tbl_BizContact", "tbl_Survey2006" "tbl_Survey2006" HAVING ( ( COUNT( "tbl_BizContact"."biz_id" ) IS NOT NULL AND COUNT( "tbl_Survey2006"."foss_supt_biz" ) IS NOT NULL AND COUNT( "tbl_BizContact"."biz_name" ) IS NOT NULL ) ) These are the results I get: Biz_id = 413328 BizName = 410058 Active = 61304 Can anyone help me get this query accurate?
