dsum in form

[deen]

Hi all,

reg amt amt total
1 10 10*50=500
1 100 100*50=5000
1 200 200*50=10000
2 2 2*50=100
2 3 3*50=150


pls see the above i was design the subform like this, but i was facing
the problem like.

in subform footer i was insert the textbox and sum the amt total is
not working.

note:amt is only display in form not store in table.

i need the result=sum([amt total])

can any one guide me for this issue.

Regards,

deen

 

[bcap]

Try this:

sum(50*[amt])

 

[deen]

Hi,

thx for reply ,

is not work out.

Bcoz amt also in form design text box not loaded in table.

how can i calculate textbox dsum.

Try this:

sum(50*[amt])

Hi all,

reg   amt   amt total
1       10        10*50=500
1      100        100*50=5000
1       200        200*50=10000
2       2             2*50=100
2        3            3*50=150

pls see the above i was design the subform like this, but i was facing
the problem like.

in subform footer i was insert the textbox and sum the amt total is
not working.

note:amt is only display in form not store in table.

i need the result=sum([amt total])

can any one guide me for this issue.

deen- Hide quoted text -

- Show quoted text -

 

[bcap]

So what *are* the underlying fields in the form's recordsource? What is amt
calculated from?

Hi,

thx for reply ,

is not work out.

Bcoz amt also in form design text box not loaded in table.

how can i calculate textbox dsum.

Try this:

sum(50*[amt])

Hi all,

reg amt amt total
1 10 10*50=500
1 100 100*50=5000
1 200 200*50=10000
2 2 2*50=100
2 3 3*50=150

pls see the above i was design the subform like this, but i was facing
the problem like.

in subform footer i was insert the textbox and sum the amt total is
not working.

note:amt is only display in form not store in table.

i need the result=sum([amt total])

can any one guide me for this issue.

deen- Hide quoted text -

- Show quoted text -