Search results

Basically, the user will choose an end-user product. and the query will bring up the entire Bill of materials for that product with all the compoments in its respective location within the BOM. it will also bring up the cost for each item, lead times and the supplier. The letters are just...

Hi, Thanks for your replies. what i am trying to do is create a multi-level bom based on a table (Excel sheet - assb) of Parent and Child fields. The expected results are shown in (excel sheet - query result). There can be a maximum of 8 levels in this BOM. What my nested IIF expression is...

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...