A part number can have subpart numbers as in above example for part 46 that has 3 subparts (46-A,46-B,46-C)
Now my dilema...
I want to keep the exact same report but where a part has a subpart I want to separately total those parts together. (only when a part has related sub parts as in 46-x .So what I want my report to look like is the following:
I know I can use the onformat event for the group section for Partnum to turn on/off the the subtotaling...but I have no clue how to do that only when I have a a part with a subpart number as in the above example.
The query that generates the output for the report is actually 7 separate queries linked by a union query....so adding another field to tie the data would be difficult..
I was hoping to create some kind of code in the on format even for the group footer that would perform the following logic.
* search for a number with a "-" and if there is one then group everything before the "-" together (that is the same) and put a subtotal in the footer.... is there any way basically to group on the fly????
By the way..my current report is sorting/grouping on partNumber