>Naomi my problem is sloving but some thing is must i want.
>in filed. rcord is like.
>studentid 1200 A,A,P,P,P,A,A,A,A,A,A,(datewise)in filed
>studentid 1201 A,A,P,P,P,A,A,A,A,A,P,(datewise)in filed
>Now i want to select if student make absence as ajasent for studentid 1200,
>should be ignore fo 1201 studentid because after 5 absence student is prasent.
>I am alos replacing with date.
>thanks for you and your thinking.

I think there may be some ingenious way to pull out the data you want using SQL rather than procedural code, but I could not invent one...