Counting records in a report

  • Thread starter Thread starter Jessie
  • Start date Start date
J

Jessie

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 !!
 
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 !!
Click to expand...


.
Click to expand...
 
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 !!
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top