Originally Posted by
gaker10
Thinking about it, I think you're right. One report might do it.
Yes, I just wanted to see how the report would place everything. I was just messing with the different UOM labels and the associated components. Basically I want the final report to read like indented code. Assembly is our "function", Component is our "if statement", Component's description and UOM etc is the if statements "arguments", and Components alternates are the body of the if statement. Best formatting example I can think of, hehe. So like this:
Assembly1
Component1, Desc, AssemblyQty, UOM, Price, Qty, etc.
Component1AltA, DescAltA, AssemblyQtyAltA, UOMAltA, PriceAltA, QtyAltA, etc.
Component1AltB, DescAltB, AssemblyQtyAltB, UOMAltB, PriceAltB, QtyAltB, etc.
Component2, Desc, AssemblyQty, UOM, Price, Qty, etc.
Component2AltA, DescAltA, AssemblyQtyAltA, UOMAltA, PriceAltA, QtyAltA, etc.
Component2AltB, DescAltB, AssemblyQtyAltB, UOMAltB, PriceAltB, QtyAltB, etc.
Assembly2
Component1, Desc, AssemblyQty, UOM, Price, Qty, etc.
Component1AltA, DescAltA, AssemblyQtyAltA, UOMAltA, PriceAltA, QtyAltA, etc.
Component1AltB, DescAltB, AssemblyQtyAltB, UOMAltB, PriceAltB, QtyAltB, etc.
Component2, Desc, AssemblyQty, UOM, Price, Qty, etc.
Component2AltA, DescAltA, AssemblyQtyAltA, UOMAltA, PriceAltA, QtyAltA, etc.
Component2AltB, DescAltB, AssemblyQtyAltB, UOMAltB, PriceAltB, QtyAltB, etc.
Components 1 and 2 could be the same or not regardless of my terrible labels. They can vary by assembly though.
The database itself never touches Excel. Whats pulled out of the database and into a table, then into a report for formatting reasons is what will be put into an excel template for pricing. Once I get everything working correctly, I think everything will be done in Access (entry and pricing/quantities), and then all the info will be exported to the excel template, either by copying and pasting or somehow placing everything automatically (not likely), and calculations are done in Excel (add prices up, input necessary labor using labor template sheets etc).
As it is was before I used Access to speed up data entry, assemblies were put directly into excel by hand. In other words, everyone was typing every part number, description, UOM etc. The purpose of using Access to do this is to automate things that do not change and prevent typing the same thing 10 times, and eliminate the frustrating typos in the final reports. However, calculations still need to be done, and those calculations are exclusive to Excel.