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
LVL 1
DavisroBudget AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UnifiedISCommented:
I would use a round function to specifically control the format

SELECT ROUND(AdjTotal, 2) As AdjTotal

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavisroBudget AnalystAuthor Commented:
Works perfectly!

thx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.