I like this idea but I'm not Savy enough in VB for the first idea.
AS for the Temp table I feel like i've tried something like this before for
another reason and although i can set up the table I seem to recall i had a
problem deconstructing the table later. not really sure what to do
thank you for your suggestion