Calculated Field in continuous form

[doobybug]

Hi,

I have a form having this format:

A, B, C, D, E, F, G

I need to produce a Total that adds A, B, C, D, E, F, G for each record

I tried to create a query and then look up the value using this:



=DLookUp("[Total]","[qryTotUniv]","[BranchId]=" & [Forms]![RegBranch1]![BranchId])

However nothing is appearing

Is there another way? Or am I doing anything wrong?

[RuralGuy]

Do the calculation in the RecordSource query of the form.

[Jim D]

I discovered a simple solution without the programming hassel to create a formula within a FORM. I needed a quick fix to this problem and everything I looked up said you cannot do this except in a query. It's not the most elaborate way, but gets the job done.

Go into design view from "Form" and select the field you wish to show the value. In that field's cell, type in the formula (almost like Excel). The trick here is that each field must be encased by brackets within the formula and the field names must be typed exactly like they appear in the Table.

Example: Field_1= Quantity Field_2 = Price Field_3 = Total Cost

Quantity x Price = Total Cost

=[Quantity]*[Price]

You will have to go into design from "Table" and be sure your fields being calculated are configured to their proper definitions.

Quantity - Number
Price - Currency
Total Cost - Currency

Hope this helps?