98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Databases and forms
excel vba courses london - Databases and forms
Resolved · Low Priority · Version Standard
Martin has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course
Databases and forms
how can i put Excel functions on Access tables
RE: Databases and forms
Hi Martin,
You create them in Queries.
In a new field, you can do simple math, and also use functions. some of the functions are slightly different, and you may need to look into the help section to verify the syntax.
some examples:
[total]*0.175 (where [total] is a numeric field)
or
GrandTotal: [total]+[vat]
Or
Total: [unit_price]*[quantity]
Regards
Richard
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. |
Excel tip:Adding a comment to a formula1. At the end of the formula, add a + (plus) sign.
|