Still Having a Problem Counting a String Field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have asked for help on this item in the past but I am still having trouble
getting it to work.

To review it, I have a database (SQL) connecting through ODBC on CR 11.
Currently there are 8 records in it (because I wanted a number I could work
with while building the report). 4 are label as 'Prenatal' and 4 are
'Infant' in the table Screenings under the field Screen_Type.

I need to Count the numer of each type I have.

I have done it this way:

Created a Formula field called PrenatalCount and inserted this formula:

IF {Screenings.Screen_Type}= 'Prenatal'
then 1
else 0

Then did a SUM on that field. I did the same for the Infant side.

I am getting a sum of 208 for Prenatal and 218 for Infant.

Can anyone help me in this? What am I doing wrong??


.