Hi Neil
Syntax is

calculate count() to lccount

but, as far as I understand, you do a SQL Select. try

lccount = _TALLY

straight after the SELECT command

Agnes
>Hi Nicholas
>
>I have tried the count command and I am having no joy
>
>

>local lccount
>Count ALL result.mainkey to lccount
>? lccount
>

>
>I get an unrecognised error problem. My cursor is named result and the field I want to count is mainkey. Any ideas?
>
>Many Thanks