Count field as a variable

[lr999]

I have a field with 0 or -1 value, I need to add a count for this field on a report. Can you provide a sample of vba code for this variable

 

[randy700]

If the field has a value of 0 or -1, it sounds like a yes/no field. What do you want to "count" ?


Randy

 

[SkipVought]

"Yes!" we have "No" banannas!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MajP]

sum([fieldName]) * -1 : total true records
sum([fieldName] + 1) : total false records
count([fieldname]) : total records