Reccount can be used with cursors, but the cursors must be true cursors (created with NOFILTER clause).
>OH thanks but i meant table name not Table and...i was going to use a cursor so ill change to _tally.(reccount) cant count cursors?
>
>
>>Ken,
>>
>>Your example syntax is confusing where you are using the word TABLE in the FROM clause. Is this the way you actually have your code written? Because that word needs to be the name of a table not the word TABLE as in;
>>
>>
>>SELECT * FROM Client WHERE client.DateApp=sdate INTO TABLE apprreport
>>
>>
If it's not broken, fix it until it is.
My Blog