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 » Forms
Forms
Resolved · Low Priority · Version 2003
Fri 20 Nov 2009, 16:26Delegate Rachel said...
Rachel has attended:
Access Advanced course
Forms
How can I put in a calculated field in my form? For example a field that will automatically calculate the VAT for me?
Mon 23 Nov 2009, 21:39Trainer Simon said...
RE: Forms
Hi Rachel,
Thank you for your question and sorry for the delay in responding.
Create the form, save it and in Design View open the Control Toolbox. Click on the Text Box tool once and draw a text box on your form.
View the Properties window and choose the Data tab and then click on the three dots at the end of Control Source to open the Expression Builder. Then add each fields you want with the appropriate operator.
I hope this answers your question.
Regards
Simon
Mon 30 Nov 2009: Automatically marked as resolved.
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:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |
