Hi,
I have written in expression for with 6 nested IIFs as shown below.
IIF(Assb_1.Child is null, PartsMaster_1.PartName, IIF( Assb_2.Child is null, PartsMaster_2.PartName, IIF(Assb_3.Child is null, PartsMaster_3.PartName, IIF( Assb_4.Child is null, PartsMaster_4.PartName, IIF( Assb_5.Child is null, PartsMaster_5.PartName, IIF( Assb_6.Child is null, PartsMaster_6.PartName, PartsMaster_7.PartName))))))
i did a trial while i was setting it up and it works when there are only 3 nested IIFs.
But when i tried it with all 6, access completely freezes and i am even able to save it.
Is there any other more effecient way of achievhing this?
Thanks!
I have written in expression for with 6 nested IIFs as shown below.
IIF(Assb_1.Child is null, PartsMaster_1.PartName, IIF( Assb_2.Child is null, PartsMaster_2.PartName, IIF(Assb_3.Child is null, PartsMaster_3.PartName, IIF( Assb_4.Child is null, PartsMaster_4.PartName, IIF( Assb_5.Child is null, PartsMaster_5.PartName, IIF( Assb_6.Child is null, PartsMaster_6.PartName, PartsMaster_7.PartName))))))
i did a trial while i was setting it up and it works when there are only 3 nested IIFs.
But when i tried it with all 6, access completely freezes and i am even able to save it.
Is there any other more effecient way of achievhing this?
Thanks!