Unless the numeric fields are nullable, it's impossible to determine if they are "empty" as 0 is an actual value.
>I have a table namely "student.dbf" havind the fields 1. Regno (I), 2. Name (C), 3. Caste (C), 4. Maths (I), 5. Physics (I), 6. Biology (I).
>
>
>I want to select the empty field value record for all the field.
>
>How to do this?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer