Kengwen,
Since you say you are counting records and don't want deleted records I'm assuming that you are not looking for the number of fields in a single record (your first line "specific fields in the table" is a little confusing). Use the deleted() function to avoid deleted records or SET DELETED ON before running the Select statement.
Select count(invoiceno) as Rcount;
from invoice;
where !deleted()
will get all records not deleted.
HTH
Barbara
>Hi,
> I want to count the no. of specific field in the table. i use the sql statement like below :
>
>Select count(invoiceno) as Rcount;
>from invoice;
>
>but i don't want then count record result include the records that had been marked deleted in the table. How to do it ?
>
>thanks.
>
>regards,
>kengwen