ciberlin
Posts: 25
|
| Posted: 10/08/2004, 9:26 AM |
|
I need to add a total count in numbers from a column that contains text. the code that I’m using now it count everything on the column but if a record is empty"null" still count it. I need the code to see it as null and not count that record.
'Custom Code @77-73254650
' -------------------------
daily.flown_summ.Value = daily.flown_summ.Value + 1
' -------------------------
'End Custom Code
ASP, SQL, IIS
thank for any help
|
 |
 |
ciberlin
Posts: 25
|
| Posted: 10/08/2004, 11:54 AM |
|
I got it working,
Now I'm looking for something similar but I need to add + 1 if the records is effective
If daily1.effective.value = "Effective" Then
daily1.effectivetotal.Value = daily1.effectivetotal.Value + 1
End If
any ideas?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/09/2004, 4:06 AM |
|
The code you included above should work OK. It may need to be placed in Grid's Before Show Row event.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
