Home > front end > For a great god!!!!!! Access using SQL query, COUNT (iif (), the result is not correct!
For a great god!!!!!! Access using SQL query, COUNT (iif (), the result is not correct!
Time：12-22
Using SQL queries in access, the following two pieces of code to get the same results (the result of the second piece of code is right), that is to say, the first code of the conditions set by the iif invalid, always can't find what reason, please god help!
SELECT COUNT (iif (='A' product classification, product number, 0)) From product sales list SELECT COUNT (product number) From product sales list
