Change Field Facts In Query?

Lets say I have a table with the following columns:

Chainname
Storenumber
Storename
Revenue in value (sold goods in $)
Revenue in volume (sold goods in pieces or SKUs)
Month

I create an Append query where I use these fields from my table:

Chainname
Storenumber
Storename
Revenue in value (sold goods in $)
Month

What happends afterwards doesn't matter, but I what if I would like to change a field in my Append query to this:

Chainname
Storenumber
Storename
Revenue in volume (sold goods in pieces/SKUs)
Month

I can do that manually by opening the Append query and then change it in the field...But can I change it without actually opening the query. Lets say using a Form were I choose if I wanna use:

Revenue in value (sold goods in $)

or

Revenue in volume (sold goods in pieces/SKUs)

??