Ok I have records that contain a total column which varies
I would like to duplicate the record by the quantity shown in the total column
Currently hold one record, need it duplicated a further 8 time
The Equipment no would then say GR-A0302-OUT012-9-B 9 times
Then the GR-A0302-OUT012-9-B would need to say
The question is can this be done with some query/script of do I have to do it manually?