How to assign a name to a computed field in Access?

F

Frosty

I really need to uncover the answer to this question rather quickly. So
anyone who can help with this please do so right away.
 
K

KARL DEWEY

If you are in the design view of the query then type the name you want
followed by a colon and then your calculation in the Field row of the grid.

If in SQL then the calculations are followed with AS [Your Display Name]
as you want it to show.
 
K

Ken Sheridan

In query design view enter the name in the 'field' row of a blank column
before the expression, separating them with a colon, e.g.

GrossPrice:[NetPrice] * (1+[TaxRate])

In SQL the equivalent is:

SELECT NetPrice * (1+TaxRate) AS GrossPrice

Ken Sheridan
Stafford, England
 
Top