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
but if i use
SELECT qMaster.*, qMaster.AdjTotal AS AdjTotal2, and format AdjTotal2 in the property window as Standard, I get
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?