Column Counts

[Guest]

I am trying to convert an old excel form to an access report. I have data
that is per site and I need to generate counts on that data.
Example:
Site Date1 Date2 Date3 Date4
A 1/1/02 1/1/02 1/1/02
B 2/1/05 2/1/05 3/5/05
C 3/1/05 3/1/05

I need it to say 3 date 1, 2 date 2, 2 Date3 and 1 Date4 so that I can then
generate %'s from the data.
Any help is appreciated.

 

[David Lloyd]

Kelly:

One approach is to use the Count function specifying the name of the field
you want the count done on. When you use a field name, rather than an
asterisk (*), the Count function does not count Null values. For example:

=Count([Date1]) 'Should return 3
=Count([Date2]) 'Should return 2


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to convert an old excel form to an access report. I have data
that is per site and I need to generate counts on that data.
Example:
Site Date1 Date2 Date3 Date4
A 1/1/02 1/1/02 1/1/02
B 2/1/05 2/1/05 3/5/05
C 3/1/05 3/1/05

I need it to say 3 date 1, 2 date 2, 2 Date3 and 1 Date4 so that I can then
generate %'s from the data.
Any help is appreciated.