replace text in query result

[nmuller]

I am working in Access 2016 with a database that lists homes and their energy usage by energy type.
After I run the query I get usage for example gas, but the column shows the code for gas and electricity. Can I change this in the query so that for example any number 1 (code for gas) is displayed as the word "Gas" and number 4 (code for Electricity)displayed as "Electric"?

 

[ranman256]

Make a lookup table, tUtility:
1, gas
4, electric.
etc...

In the query,join this table to your data table on the common field,bring in tUtility.Code,
tUtility.Name

 

[nmuller]

Make a lookup table, tUtility:
1, gas
4, electric.
etc...

In the query,join this table to your data table on the common field,bring in tUtility.Code,
tUtility.Name

Thanks, I'll try that