The code fix in the link I had provided above did work for me so I documented my efforts there.
Thanks for your advice Paul! While I liked the CrossTab query (if it would avoid VBA) I needed far more fields than I was listing in my example that would render it very cumbersome if useful at all...