I am trying to retrieve a "sum" of a "count". I guess that can be done. Here is the count query. How do I get a total for the count? Thanks in advance.
SELECT tblBicycles.Make, tblBicycles.Model, tblBicycles.Size, tblBicycles.Color, Count(tblBicycles.Warehouse) AS CountOfWarehouse
FROM tblBicycles
WHERE (((tblBicycles.Status)=2))
GROUP BY tblBicycles.Make, tblBicycles.Model, tblBicycles.Size, tblBicycles.Color;
SELECT tblBicycles.Make, tblBicycles.Model, tblBicycles.Size, tblBicycles.Color, Count(tblBicycles.Warehouse) AS CountOfWarehouse
FROM tblBicycles
WHERE (((tblBicycles.Status)=2))
GROUP BY tblBicycles.Make, tblBicycles.Model, tblBicycles.Size, tblBicycles.Color;