how to count in the report

[c_atasoy]

--------------------------------------------------------------------------------

Hello, I want to count records what have hypen '-'. For instance;
records values
1 612001-612002-612003
2 612004
3 612005-612006
4 612007
5 612008
6 612009-612010-612011
the result must be 5

does anyone know how to do it in a report

 

[Liv Manto]

if the report is based on a query, add a field in your query

iif(instr([table.field1],"-")>1, 1, 0)
Then sum it up in your report if you have a summary row there.