Hello. I'm a new Access user, and I find myself a little over my head in a database I have to build, or rather the report I need to get from the database. The records list the pieces of a machine spanning levels of complexity from an individual, shaped piece of metal to an assembly of moving parts.
Currently, this is what I have in my records:
Item Number| Item Name | Item Status | Next Assembly | Part Level
The Item Number is the unique ID key.
The name is just that.
The status is the level of production.
The next assembly is the assembly of parts that the part, or subassembly in question belongs to.
The part level is the level of complexity, with level 1 being the entire machine.
My question is this: How can I take that information, or this and additional fields, to get an output that lists each item, starting with the entire machine, and branching out to each of the assemblies, sub assemblies and individual parts, each next level down indented below the one above it.
For example:
Examples given in: 'item number' 'item name' 'status' format
123 Top Assembly Released
124 Assembly Not Released
100 Sub Assembly In Review
200 Part2 Released
345 Assembly2 Released
875 Part3 Not Released
The reports I have produced through the wizard come out with duplicate item numbers and names, as they are listed from their own record as well as being the Next Assembly for others, and tend to not order the parts correctly. Managing to fix that issue, I'm left with the problem of the parts not being properly indented to denote level.
I have very limited experience with coding, and was looking into what I could do with VBA, but the progress is slow and I'm pushing a deadline. Can anyone offer any help with how I can manage to get the results I need?