hi, hoping you can all help.
I am possibly being a bit naive in thinking i can transfer an 'if' design from EXCEL into ACCESS;
I essentially want to do waht this does in access:
=IF($BD2="",IF($AW2="",IF($AO2="",IF($AH2="",IF($AD2="","",$AD2),$AH2),$AO2),$AW2),$BD2)
I want access to look...