Hi,
Yes, I've done this sort of thing in VBA code before, but was hoping there was a way I could just do it in a query. This is just a single table....not a 1:M relationship.
And to my knowledge, the order of your columns in a query don't need to match those of the table. :-)