Ok firstly thanks for reading this post I really do need some help
I have a row of 5 codes for individual marks - P for Pass and F for Fail. In the last column I have the overall result - P if all individual results were P and F if any of the 5 results were an F.
My problem is that if no data has been entered the final result defaults to an F for Fail when in fact I would like it to show blank or space.
I think this problem is something to do with NULL value but I'm not sure what to do to resolve this. Any help or guidance will be greatly appreciated. Cheers.
I have a row of 5 codes for individual marks - P for Pass and F for Fail. In the last column I have the overall result - P if all individual results were P and F if any of the 5 results were an F.
My problem is that if no data has been entered the final result defaults to an F for Fail when in fact I would like it to show blank or space.
I think this problem is something to do with NULL value but I'm not sure what to do to resolve this. Any help or guidance will be greatly appreciated. Cheers.