|if the absence code that is on the days absence record is of a certain value|
Sorry, don't follow what your trying to do.
Post a small sample of your work sheet, with a before & after if possible.
First read this:
It will show you how to post in these forums using the PRE tags.