emanuele
the old good fellow Bill
- Local time
- Tomorrow, 00:40
- Joined
- Jan 23, 2003
- Messages
- 23
Please some help.....
A form called "Members" based on tables: "Profile" and "Points registration" and "Bonus level") shows all information about my club members. I would like to have on the form the datas from the field "Level" in table "Bonus Level". This should uppdate automatically based on the following Sum also shown on the form:=OOM(IsNull([MemberNr]);0;DSum"[Points]";"Points Registration";"[MemberNr]=" & [MemberNr]))
so that for "GivenPoints" >=0 and <10 : "Bonus Level" = 1!!! For "GivenPoints" >=10 and <30 : "Bonus Level: 2!!! and For "Given Points" >30 "Bonus Level" : 3!!!
How do I write the query?
A form called "Members" based on tables: "Profile" and "Points registration" and "Bonus level") shows all information about my club members. I would like to have on the form the datas from the field "Level" in table "Bonus Level". This should uppdate automatically based on the following Sum also shown on the form:=OOM(IsNull([MemberNr]);0;DSum"[Points]";"Points Registration";"[MemberNr]=" & [MemberNr]))
so that for "GivenPoints" >=0 and <10 : "Bonus Level" = 1!!! For "GivenPoints" >=10 and <30 : "Bonus Level: 2!!! and For "Given Points" >30 "Bonus Level" : 3!!!
How do I write the query?
Last edited: