Change General number format in SELECT * query

I have a numerical column "AdjTotal" formatted as Standard in a main query where i've combined multiple tables into a master dataset (lets call it qMaster). From qMaster I've set up additional queries to process different subsets of data

If i then "Select qMaster.*" in a new query, the AdjTotal column displays in General format, which I don't want, but if I add a second instance of the column, alias it, and format it as Standard in the field properties, then they both change! So:
 
SELECT qMaster.* displays
Adj_Total
1544.55485
1648.25847

but if i use
SELECT qMaster.*, qMaster.AdjTotal AS AdjTotal2, and format AdjTotal2 in the property window as Standard, I get
AdjTotal   AdjTotal2
1,544.55    1,544.55
1,684.26    1,684.26

and if I deselect the Show checkbox on AdjTotal2 i get just the original AdjTotal column formatted as Standard, which i do want.

Is this a correct treatment to format a column within a Select * population?

thanks