I have used the Union query to count the number of values in a range, is there an alternative option??
This is what I created for unit cost (AUP), and it works fine. But I have a lot of 0 values, I tried to modify the query to count the zero values without success. Can anyone help?
This is the first two lines of the SQL to count 0-50 and 50-100
SELECT Count(SPD1.AUP) AS CountOfAUP, "0 to 50" AS Rng
FROM SPD1
WHERE (((SPD1.AUP)>0 And (SPD1.AUP)<50));
Union
SELECT Count(SPD1.AUP) AS CountOfAUP, "050.01 to 100" AS Rng
FROM SPD1
WHERE (((SPD1.AUP)>050.01 And (SPD1.AUP)<100));
Many Thanks Dave