access form continuous

[sekoma]

i have access continuous form with 2 fields i want calculate sum like this ((first record when i type data1 field1 its =data1 field2 and second record data2 field2 =data1 field2 +data2 field1 ,third record data3 field2 =data2 field2 +data3 field1 and it courteous automatically how to do this in access form

regards

 

[strive4peace]

hi @sekoma

Reports have a Running Sum property so it's easy there ...

Choices are

• No
• Over Group
• Over All

To show a running sum on a form, you need to do a calculation. Easiest would be to use DSum. The problem though, is what if the form is sorted differently? Or there is criteria to consider? Showing a running sum on a form is not so easy.

 

[sekoma]

Thanks all
i need this calculation in form because i have data base it contains combo box it linked with subform the subform its view as worksheet ,so in sub form i have amount field and balance when i type a mount it be calculate in balance like excel sheet

 

[GPGeorge]

Thanks all
i need this calculation in form because i have data base it contains combo box it linked with subform the subform its view as worksheet ,so in sub form i have amount field and balance when i type a mount it be calculate in balance like excel sheet

Did you know you can use a report in a subform control?

 

[CJ_London]

access does not work like excel

so for the second row you would be adding the first and second row, for the third row you would be adding all the records between first and third rows, the next first and fourth, etc

if your subform is not being edited and is just for display you can use a report as a subform

 

[sekoma]

thanks for replay
i know create reporting for sub form, and the subform it be add or edit data. so i want record by record give me balance foe exam: for first record i add amount 5 $ it equal balance for second record when i add amount 10 $ the balance field =5+10=15 and third add amount 2$ the balance =15+2=17 thats like the attach photo
regards

 

[sekoma]

I mean like this attach photo I taken a pic from other data base

 

[CJ_London]

why not look at how the other database has done it?

 

[sekoma]

Thx all for replay

pat hartman how is it too easy can you explain how i can do this with whitch way



regards

 

[Gasman]

Now crossposted at https://www.accessforums.net/showthread.php?t=86215

 

[sekoma]

Open the other form and see what the running sum control is bound to and follow that thread. Or, read the articles I linked to and try to implement on of those solutions.

im using the dsum in vba
BALANCE = DSum("[Amount]", "[QDRDE]", "[INVONO]=" & Me.INVONO)
but i see all balance calculated for all account , so thats I want when i change Unbound cbo.MRC in the main form the subform updated and the balance must calculate only for this account that's show in cbo.mrc the attach photo that explained what i want and thats access i created
regards

 

[arnelgp]

add an Autonumber field to your Table.
now add this autonumber field to your continuous form,
you can then get the Balance (I used ID as autonumber)

=DSum("[Amount]", "[QDRDE]", "[INVONO]=" & Me.INVONO & " And ID <= " Me!ID)

 

[CJ_London]

think the code you have posted is not the code you are using

you posted "[INVONO]=" & Me.INVONO

think you are actually using "[INVONO]<=" & Me.INVONO

which is correct

but looks like you need another criteria

"[INVONO]<=" & Me.INVONO & " AND [Account]=" & Me!Account

 

[sekoma]

think the code you have posted is not the code you are using

you posted "[INVONO]=" & Me.INVONO

think you are actually using "[INVONO]<=" & Me.INVONO

which is correct

but looks like you need another criteria

"[INVONO]<=" & Me.INVONO & " AND [Account]=" & Me!Account

thanks
i understand at your information and it solved correctly Thank you