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 at one field, and if blank move to the next one, if it has any wording in it, i want it to return that.
The background is that i am trying to find the end state based on outcome returns from 6 reports. The fields are either blank or have 'Complete', Not Complete'. My end state would be for the right end column to say 'Complete', 'Not Complete' or be blank (tho there shouldnt be any blanks).
My query field list is:
UNIQUE IDENT/ OCT / NOV/ MOPUP / DEC
My thinking is that the query would look at Dec, and return Complete/ Not Complete, if blank, move back to MOPUP and do the same all the way through until when it gets to OCT when if its blank, it will return blank.
I initially just copied the excel idea into an 'iif', but it doesnt seem to work for three way outcomes.
Any ideas?
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 at one field, and if blank move to the next one, if it has any wording in it, i want it to return that.
The background is that i am trying to find the end state based on outcome returns from 6 reports. The fields are either blank or have 'Complete', Not Complete'. My end state would be for the right end column to say 'Complete', 'Not Complete' or be blank (tho there shouldnt be any blanks).
My query field list is:
UNIQUE IDENT/ OCT / NOV/ MOPUP / DEC
My thinking is that the query would look at Dec, and return Complete/ Not Complete, if blank, move back to MOPUP and do the same all the way through until when it gets to OCT when if its blank, it will return blank.
I initially just copied the excel idea into an 'iif', but it doesnt seem to work for three way outcomes.
Any ideas?