I haven't used a database since I retired six years ago and never used
Paradox before. My office used Alpha 4 and I was able to work with
that in setting up an application to handle our trust account (I was
an attorney).

I have 84 records where a field requires a Y or N answer. I would
like my report to summarize the field by stating how many of each
there were. I would need a field to transfer the y to a number and a
field to add the numbers. I can't get the report to do either and the
program help is of none.

I can get the answers by sorting on the field but that's not the same
as having it show neatly at the end of a report.

Many thanks.
-----------------------------------------------
Gary
..

if you're new to Paradox, this calc might seen like it's from way out in
left field, but.. these two calcs will do the trick..

SUM(IIF([my field] = "Y",1,0))
SUM(IIF([my field] = "N",1,0))

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

Thanks very much.

On Sat, 25 Feb 2006 11:42:13 -0500, "Steven Green"
<greens (AT) diamondsg (DOT) com> wrote:

Gary
..