Jessie,
Is this a Text field that contains a "+" ("hydrogen + oxygen")?
Or is this a number field that shows a + for positive values and a - for
negative values, (+185.95)?
If this is a text field, place the control in the Group Header or Group
Footer.
It works fine for me.
If it is a Number field, change the control source to:
=Sum(IIf([SomeField] >0,1,0))
Also place it in the Group header or Group Footer.
It works fine for me.
--
Fred
Please reply only to this newsgroup.
I do not reply to personal e-mail.
Jessie said:
Fred - That is returning a 0 value for all of my groups
even those that contain the "+" . Any other ideas??
Thank you for your help !!
-----Original Message-----
Jessie,
Try something like this:
=Sum(IIf(InStr([SomeField],"+")>0,1,0))
--
Fred
Please reply only to this newsgroup.
I do not reply to personal e-mail.
Jessie said:
I need to count the number of records in each group of my
report that contain a "+" sign. I have been able to
create an expression to count all of the records in my
group but I an having difficulty creating one that counts
only those containing a "+".
Thank you for your help !!
.
