I need a script that will find and delete all the empty record I have.

how do i go about doing this? I tried many things but im stuped. it keeps deleting all the records. good thing i made a backup!

You need to make a "Found Set" of the qualifying Records First.

To find a record that has no data in "ONE" field, you Perform a Find using the "=" equal sign (no quotes).

To do this manually.

Enter "Find" mode.

Type an = in your selected field (Field 1)

Hit the "Find" button.

This will find all records that do NOT have data in the one field you choose.

To be sure that the records you want to delete are blank, do a "And" find.

This is done by entering the = sign in more than one field in one Find Request.

Enter "Find" mode

go to Your First Field, enter =

go to Your Next Field, enter =

go to Your Next Field, enter =

and so on until you feel that you have covered your bases

Hit the Find Button.

This will find all records that do NOT have data in all of the field you choose.

HTH

Lee

I should have added that you then go into the Menu >> Records >> Delete Found Records.

It changes when you have a found set from Delete All Records.

Thank you very much!