>>use table1 >>if reccount() > 0 >>... >>>>the only problem is that this table could have a deleted record, very hard to use excl and pack and i want reccount() to only work with non-deleted records, is there a way to do this?
USE table1 >GO BOTTOM >IF NOT BOF() AND NOT EOF() >... >That actually answers the question in the message itself and not in the title! :)