Don Parris ha scritto:
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?
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.6/430 - Release Date: 28/08/2006
Hello,
the only criteria you have to use are 0 and -1.
Best regards,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
