W
wonderin32
I'm basically a beginner in Access, but trying to become more proficient.
Generally I pull data into Excel to manipulate, but I've run up against too
big a database.
I'm trying to count all of the records that have a value of greater than 0.
I'm pulling from another query that has multiple records. The details are:
Multiple months of sales information (this is where I'm trying to count >0).
Multiple franchise locations and multiple SKUs.
I'm trying to pull how many franchise locations Sales of >0 units for each
SKU.
I'm good with the SELECT piece, but COUNT is just counting all of the
records. I tried COUNT(IIF(X)>0), but that didn't seem to work either.
Everything was coming up 1's.
Any ideas?
Generally I pull data into Excel to manipulate, but I've run up against too
big a database.
I'm trying to count all of the records that have a value of greater than 0.
I'm pulling from another query that has multiple records. The details are:
Multiple months of sales information (this is where I'm trying to count >0).
Multiple franchise locations and multiple SKUs.
I'm trying to pull how many franchise locations Sales of >0 units for each
SKU.
I'm good with the SELECT piece, but COUNT is just counting all of the
records. I tried COUNT(IIF(X)>0), but that didn't seem to work either.
Everything was coming up 1's.
Any ideas?