Thanks for the help.  I understand why the results were incorrect now.

Also, this query is needed to format one column and will later be joined with a larger query by...