concatenation for a field, keeping the masking data

[finneyz]

I have a nice laid out query, trying to keep the masking fields.
aka !000\V/00"Ph"/00"Hz";;_
sample, 480V/60Ph/03Hz

when I use my query to concatenate the fields, it comes out as 4806003

how is it possible to keep the fields with the masked inputted data? with the !000\V/00"Ph"/00"Hz";;_

sql
[cat_tbl.cat_name] & (","+[subcat_tbl.sub_cat_name]+",") & (" "+[copy of parts_tbl.parts_material]+",") & (" "+[copy of parts_tbl.parts_specification]+",") & (" "+[manuft_tbl.manufact_name]+",") & (" "+[copy of parts_tbl.manufact_model_no]+",") & (" "+[copy of parts_tbl.parts_finish]+ ",") & (" "+[electrical_data_tbl.electrical_data]) &"." AS full_description,

it fits into electrical data field and table,
sample output

Cable, Power & Control, Low Voltage, Shipboard,Unarmored, Low Smoke Zero Halogen, Copper, ASTM B8, The Okonite Company
, 116-67-1101, Green, 2086003.

 

[finneyz]

update. I was able to make a separate query with the input masks
it works, but can you query a query.... and a specific column

 

[finneyz]

I've tried subquery but not sure of how to use the zoom feature with expressions

 

[finneyz]

I've tried something like this, MynewFieldNameHere:Format([electrical_data],"!000\V/00"Ph"/00"Hz";0;_")
gives me an invalid syntax error.
Is it possible to make a field, and requery the same field in a query

 

[finneyz]

Ive also tried some random things like
mytbl: [electrical_data] (using the masking in the query not the table) works great
then I add in mynewtbl: [mytbl] && [full_description]
output is 4806003.
is it possible to keep it in the same field, masked