G Guest Sep 18, 2006 #1 I really need to uncover the answer to this question rather quickly. So anyone who can help with this please do so right away.
I really need to uncover the answer to this question rather quickly. So anyone who can help with this please do so right away.
G Guest Sep 18, 2006 #2 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.
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.
G Guest Sep 18, 2006 #3 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 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
