Counting values in columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have read numerous posts herein and still can't seem to find what I
need...sorry if I have missed something this simple.

I would like display a total in the Report Footer from counting certain
values w/in a column.

The column is named [ID/POTENTIAL], w/ a drop menu to select "Site",
"Project", "Area" or leave blank and I would like to count and display the
number of times either Site or Project is given as the answer.
 
Scotts said:
I have read numerous posts herein and still can't seem to find what I
need...sorry if I have missed something this simple.

I would like display a total in the Report Footer from counting certain
values w/in a column.

The column is named [ID/POTENTIAL], w/ a drop menu to select "Site",
"Project", "Area" or leave blank and I would like to count and display the
number of times either Site or Project is given as the answer.
Click to expand...


For just a couple of items, you can get away with using text
boxes with expressions like:

=Sum(IIf([ID/POTENTIAL] = "Site", 1, 9))

But, in the long run and depending on the report's criteria,
you would probably be better off using a subreport based on
a query like:

SELECT [ID/POTENTIAL], Count(*) As CountOfID
FROM yourtable
GROUP BY [ID/POTENTIAL]
 
Back
Top