If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating in reports
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? |
#2
|
|||
|
|||
Calculating in reports
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 -----Original Message----- 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? . |
Thread Tools | |
Display Modes | |
|
|