From the description, I have the impression that your table is not normalized. It would be much easier to manipulate if, instead of one record in the table described, you had 24 records in a secondary table.
>Dear all
>How can chek the empty fields.
>e.g
>i am replacing the records. Max01=50 and obt01=25
>i chek the rcords of max01........max24 if not emppty and obt01........obt24 is empty.
>These are diffrents fields. But these are related to each other.
>
>relations like this
>
>max01 relate obt01
>max02 relate obt02
>
>...........
>
>max24 relate obt24
>
>I am replacing the records in my current work only for obt01........obt24
>max01........max24 already replaced.
>
>
>
>Now i want to check the empty field obt01........obt24 and not empty max01 ....max24.
>
>
>
>may be i have explaned
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
