grouped totals on a form.

[jon2192]

How on a form could i get the sum of a qty field where another field = yes or no

I know how to do this in a query.

But can i do it as a calculated control and still see all the data in form.

i.e.
qty y/n
10 y
20 y
15 n

total y = 30 total n = 15
thanks for any help.

 

[doran_doran]

You can write the values on exit or on close

Hello,

you can write these values to your field on exit or before update event.

Make ur calculated field unbound (names txtcalculatedfield1, txtcalculatedfield2 and etc)

and on exit or before update u can put like following.

[tables]![tableCustomers]![txtactualfield1] = me.txtcalculatedfield1
[tables]![tableCustomers]![txtactualfield2] = me.txtcalculatedfield2

Do some search you will find the solutions.

Regards

Dianna Goldsburg

How on a form could i get the sum of a qty field where another field = yes or no

I know how to do this in a query.

But can i do it as a calculated control and still see all the data in form.

i.e.
qty y/n
10 y
20 y
15 n

total y = 30 total n = 15
thanks for any help.