Calculating in reports

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

i'm pulling 12 fields from a query 6 of which have names
of people ie field1 jane doe, field2 drew smith, field3
jim doe, field4 jack smith, field5 tom smith, and field6
diane marie. If the field is blank i want it to be 0 and
if it has a name in it i want it to be 1 thus i can count
how many groups i have. I thought i might need to do this
on the report open event and do a loop but i am not sure.
Can anyone help me?
 
You could do this with
=Abs(IsNull([Field1])+IsNull([Field2])+IsNull([Field3])
+IsNull([Field4])+IsNull([Field5])+IsNull([Field6])+IsNull
([Field7])+IsNull([Field8])+IsNull([Field9])+IsNull
([Field10])+IsNull([Field11])+IsNull([Field12])+12)
all on one line this will give you a count of the entries
per record
Hope this helps.
Fons
 
Back
Top