Continuous form Total

[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 to sum these fields 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?

 

[SeeThru]

In the data source, add a new field

MyTotal: [A]++[C]+[D]+[E]+[F]+[G]

Then in the form add a new field bound to MyTotal. Set it to locked



SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages

 

[doobybug]

Should a total never be saved?

 

[doobybug]

Another thing by data source what do you mean?

 

[TheAceMan1]

How are ya doobybug . . .

[blue]SeeThru[/blue] is on target however I'd spiff it up a bit to take care of nulls:

[blue]MyTotal: Nz([A], 0)+Nz([B], 0)+ ... Nz([G], 0)[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]