Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Twin Cities, MN USA

    Question Unanswered: Exploded Bill of Materials

    In a table, I have an "Item Numbers" field and a "Number Type" (limited to "Assembly" or "Component") field. I have another table with "Assembly", "Component", and "Quantity" fields. I fill the first two fields in the second table with "Item Numbers" from the first table and fill in the "Quantity" field. Creating a report that lists all of the components and it's quantity for a given assembly is easy. But I also want the report to do a subreport (perhaps the wrong term, here) each time the component's number type is an assembly. Suggestions?
    Last edited by pg3t; 09-04-02 at 11:05.

  2. #2
    Join Date
    Jan 2002
    At the Edge of America!

    Re: Exploded Bill of Materials

    Create a TEMP table in Access. Go through your records and create a report table. Each time you run that report you go record by record and append the table with the data. The report will be based off of the temp table. Each time you close the report run a delete *.* from the table to empty the contents.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts