Search results

  1. A

    Simple Query Needed

    Thank you Rak :) :) Thanks a lot Rak.
  2. A

    Simple Query Needed

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

    Would like like to improve my Query

    Enclosed with the mdb file Enclosed with the mdb file.
  4. A

    Would like like to improve my Query

    Thanks Banana Hi Banana, Thanks for your input, I am just a beginner, probably you can help to highlight my SQL and point out or enhance it. Thanks.
  5. A

    Would you like to improve my Query

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

    Would you like to improve my Query

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

    Would like like to improve my Query

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

    Looking For Simple Query SQL Command

    Thank you, it works Thank you very much, it works fine.
  9. A

    Looking For Simple Query SQL Command

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

    Single Level to Multilevel BOM Conversion

    Excellent, thanks for your input. Excellent, thanks for your input. I am looking for something with the multi BOM level, 1 | FG1 | FG1 | SA1 | 1 2 | FG1 | SA1 | SA3 | 2 3 | FG1 | SA3 | CO3 | 2 2 | FG1 | SA1 | CO2 | 3 1 | FG1 | FG1 | CO1 | 4 1 | FG2 | FG1 | SA2 | 1 2 | FG2 | SA2 | SA3 | 4 3...
  11. A

    Single Level to Multilevel BOM Conversion

    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...
Back
Top Bottom