Access form continuous


Joined
Jun 28, 2022
Messages
1
Reaction score
0
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
 

Attachments

  • Untitled.png
    Untitled.png
    91.5 KB · Views: 5
Ad

Advertisements

Joined
Nov 2, 2022
Messages
1
Reaction score
0
what you need is a Running Sum query:

select id, n, dsum("n","a","id <= " & [id]) as sumOfN from a;

then use the query for input or create a form from the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top