Prev: Sync subforms
Next: Creating report with date counts
From: Chipgiii on 10 Feb 2010 13:34
I want to generate a report: I want to count blank cells. The data has a
date and a repair date (separate columns). What I would like to do is count
the number of blank repair dates (this reflects the amount of lights, in this
case, that have not been replaced). I then want to divide that by the fixed
number of total lights in the greenhouse so I can tell each week, or month
the percentage of lights needing repair in a report. I am a real novice user
simplicity is a must.


--
Thanks,
Chip
From: Arvin Meyer [MVP] on 10 Feb 2010 14:34
You can write a query like:

SELECT tblMyData.RepairDateField, Sum(1) AS FieldCount
FROM tblMyData
GROUP BY tblMyData.RepairDateField
HAVING (((tblMyData.RepairDateField) Is Null));

Then use that query's result your in report calculation.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Chipgiii" <Chipgiii(a)discussions.microsoft.com> wrote in message
news:C01DC82F-5756-477D-804D-8CA134583C15(a)microsoft.com...
>I want to generate a report: I want to count blank cells. The data has a
> date and a repair date (separate columns). What I would like to do is
> count
> the number of blank repair dates (this reflects the amount of lights, in
> this
> case, that have not been replaced). I then want to divide that by the
> fixed
> number of total lights in the greenhouse so I can tell each week, or month
> the percentage of lights needing repair in a report. I am a real novice
> user
> simplicity is a must.
>
>
> --
> Thanks,
> Chip


 | 
Pages: 1
Prev: Sync subforms
Next: Creating report with date counts