98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - How best to use the "expression" tool in queries | Access forum
access+course+training - How best to use the "expression" tool in queries | Access forum
Resolved · Low Priority · Version Standard
Wed 28 Mar 2007, 09:38Delegate Ainul said...
Ainul has attended:
Access Intermediate course
Access Advanced course
How best to use the "expression" tool in queries
I have seen this tool been used but what are the functionality around this tool and where and when should it be used?
Wed 11 Apr 2007, 10:03Trainer Carlos said...
RE: How best to use the "expression" tool in queries
Ainul
The "Expression" tool accessed by the Build button is very useful to create (build) Calculations and Formulas in the query, using both normal syntax and Functions.
For example
In a Query listing all the Orders received a field can be created to calculate the Total value of the order by :
Multiplying the Amount Ordered by the Unit Price
Regards
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |
