How to change field names in queries

[scottsoo9]

I had to put expressions in some of the fields of my query and I would like to change the field name to a different name besides espresion1 or expression2 or so on. I try to go to properties of each field and change it there and it will not let me. Any suggestions? Thanks, Scott

 

[MSAccessRookie]

Include the phrase "As <YourFieldName>" after the Formula and see if that gives you what you want.

 

[scottsoo9]

My originial expression is Expr1: [Dollars Expended]-[Amount Invoiced]



I tried Expr1: [Dollars Expended]-[Amount Invoiced] "As <EXP Bill>"

That did not work and I have tried it a few other ways. Sorry if these questions are very simple but I am very new to this. Scott

 

[Kryst51]

Can you not replace "Expr1" with whatever you want in your formula

i.e.

EXPBill: [Dollars Expended]-[Amount Invoiced]

 

[boblarson]

My originial expression is Expr1: [Dollars Expended]-[Amount Invoiced]



I tried Expr1: [Dollars Expended]-[Amount Invoiced] "As <EXP Bill>"

That did not work and I have tried it a few other ways. Sorry if these questions are very simple but I am very new to this. Scott

MSAccessRookie was giving you the stuff if you were in SQL view and not Design View in the QBE (query by example) grid. Kryst51 gave you the answer for if you are in the QBE grid.