I have a door manufacturing customer that would you believe makes domestic doors. It is common in the industry to have a door described as door type and then all of the individual doors have there own door number. So a typical order may be 20 Type A and then door numbers D01 to D20. But often doors are not manufactured by type, rather by batch. So there could be 8 in the 1st batch and 12 in the second. So I need a way for the 8 doors in the first batch to read Door type "Type A" where door numbers in 1st batch are "D01, D06, D07, D12 etc.
If you look at query 1 then query 2 and then 3 it should show what is required. Basically it is concatenating all of the door numbers associated with different batches (1st and 2nd). I have included the concat code (Module4) used in a form that concatenates all of the doors associated with a door type listed on a form. But I really need the results in a query.
The last op is easy I can use grouping to compress the data as in "Final result"