UtterAccess Discussion Forums > add to fields in a form

UtterAccess Discussion Forums > Microsoft® Access > Access Reports

Cguckian

Nov 3 2005, 07:23 AM

Hi I am building my invoice and have got my total and vat fields. i basically want to know how to add two fields together

thanks

dashiellx2000

Nov 3 2005, 07:42 AM

In the text box control source you put:

= [FieldOne] + [FieldTwo]

HTH.

Cguckian

Nov 3 2005, 07:47 AM

tried that and it is asking for parameter values

dashiellx2000

Nov 3 2005, 07:57 AM

Are your Totals and Vat field calculated controls? If so, you should calculate them in the underlying query and then your report calculation will work.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.