Create a calculation field in Access

[m.vesali]

Hello to the professors
I had a simple question about Access. Please help if you can.
I use simple nouns to understand better.
I have a table called "table" that has 4 fields.
Something like this
Hope to be understandable

Field # 1 - Field # 2 - Field # 3 - Field # 4
Name 1---- Name 2 ------ 4
Name 2---- Name 1 ------ 1
Name 3---- Name 2 ------ 3
Name 4---- Name 1 ------ 2

First, the members in field # 2 must find their value from field # 3
For example: Name 1 = 2 + 1 = 3
And the Name 2 = 4 + 3 = 7

Now the field # 4 must be calculated automatically for field # 1, and names that do not have a value are equal to 0. Like below:

Field# 4
3
7
0
0

Is there a way to do this
thanks for your help

[ranman256]

your explanation makes no sense.
is the value in [FLD 1] = "name 1" ...which is a string and has no value.

can you explain in excel forumula:
[fld 1]=[fld ?]+[fld ?]
[fld 2]=[fld 3] + [fld ?]

[CJ_London]

First, the members in field # 2 must find their value from field # 3

this cannot be done in a calculated field in a table, you need to use a query

I do not understand your example, provide a better clarification of your data

[m.vesali]

excuseme for my bad explanation
I want to use the sumif function between field one and field two, like excel
You think my table has the same detail in excel
Then we will have:
= SUMIF ([field2]; [@ field1]; [field3])

[m.vesali]

Field one and the second field are of type text and field three and the fourth field of type number
I want the above formula to be computed in the last field.

[m.vesali]

Field 1 members are Unicom
And Field 2 members are derived from Field 1, but not Unicom

[m.vesali]

May you guide me?
Thanks.

[m.vesali]

No one knows the solution?
Let me know if my description is difficult!

[CJ_London]

nobody understands your requirement so as requested please provide real example data and clearly demonstrate what the calculation is. Your Sumif example would be a simple group by query in Access, but does not match the description of your requirement.

Just a guess but this link perhaps asks the same question

https://www.accessforums.net/showthr...364#post413364