Forms

Resolved · Low Priority · Version 2003

Fri 20 Nov 2009, 16:26 Delegate 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:39 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips