Hello,
I have a display on the form that shows the position in the table like 3/30, which means record # 3 from 30 total.
I get the 30 with COUNT function, and the 3 with RECNO().
However, when there are deleted records in the table, COUNT returns the number of not deleted records (which I like), but RECNO() returns the real position in the table, including deleted records.
So it can look like 35/30 which is weird.
What can I do to get the record number but excluding counting of deleted
records?
Thanks for your help in advance!
Christian Isberner
Software Consultant