Search results

Hi, I have data that I imported into access (Table1). Basically, the file shows two values with Header, Component. I need to group the Component together with a delimiter & (or any symbol) when the header is the same. For example of what I have: Table1 Field 1 – Header Field 2 - Component...

Hi, I have a Query which used to construct indented Bill of material from a single level bom table. (Parent, Component, qty, OpSeq & ItemSeq) to a query result (Top FG, Subassembly, Parent, Component, Qty, OpSeq & ItemSeq). Current query has limitation of creating duplicate records and it's...

Hi, I have a Query which used to construct indented Bill of material from a single level bom table. (Parent, Component, qty, OpSeq & ItemSeq) to a query result (Top FG, Subassembly, Parent, Component, Qty, OpSeq & ItemSeq). Current query has limitation of creating duplicate records and it's...

Hi, I have a Query which used to construct indented Bill of material from a single level bom table. (Parent, Component, qty, OpSeq & ItemSeq) to a query result (Top FG, Subassembly, Parent, Component, Qty, OpSeq & ItemSeq). Current query has limitation of creating duplicate records and it's...

Hi, I am looking for a Access Query SQL Select command. I have data that I imported into access (Table1). Basically, the file shows Item cost with item number, cost amount & cost type. I need to add the cost amount for "Burden" cost type into Overhead cost type. For example of what I...

Hi, I have data that I imported into access (Table1). Basically, the file shows single level BOM (Bill of Material) with BOM Header, BOM Component, Qty per. I need to construct a Multilevel BOM (Table2) base on the single level BOM file, with BOM Level, Finished Good, Subassembly BOM header...