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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really need to uncover the answer to this question rather quickly. So
anyone who can help with this please do so right away.
 
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.
 
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
 
in design view:
answer: [X] + [Y]

in SQL view:

( [X] + [Y] ) AS Answer
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Count and assign 2
Count text values in a Access Field 0
USB Com ports 6
Query field name changes from "Aug-08" to "Aug-8" 6
Split data in field on character return 0
Oversensitive touchpad on modern laptops 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0

Back
Top