Recent content by ac916

  1. A

    Simple Query Needed

    Hi CJARD, I need to group by the header to get all component in one line. It can be FG1 | SA1 SA2 CO1 FG2 | SA3 CO2 Thanks.
  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: What I am trying to get is Thanks Andrew
  3. 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...
Top Bottom