Help on Calculated Formula

[vinchacho]

Hi! First of all i have 3 different colums in my form:- membershiptype[1 year
or 5 years] and employmentstatus[employed or unemployed] and membership fees.

If i want to calculate membershipfees based on membershiptype and
employmentstatus:

If membershiptype = 1year and membershipstatus = unemployed then

membereshipfees = 5 else if

membershiptype = 1 year and membershipstatus = employed then

membershipfees = 10 else if

membershiptype = 5 years then

membershipfees = 70 . . . then return the value to my table. . .

Can anyone please help me on the formula for this. Thank you very much in
advance.

 

[BruceM]

You would do well to use combo boxes, or maybe option groups, to list
MembershipType and EmploymentStatus. In the After Update event of the
EmploymentStatus combo box you could have:

If Me.cboMembershipType = "5 years" Then
Me.txtMembershipFee = 70
Else
If EmploymentStatus = "Employed" Then
Me.txtMembershipFee = 10
Else Me.txtMembershipFee = 5
End If
End If

This assumes there will always be an entry in both combo boxes. There are
various ways you could assure an entry in both fields, and that neither
field can be cleared after the record has been saved, but I won't try to run
through all of the options.

The text box txtMembershipFee could be bound to a MembershipFee field if you
need to save the data independently of the MembershipType and
EmploymentStatus data. Otherwise you should just leave it as an unbound
text box, and perform the calculation as needed.

 

[Fred]

I noticed that nobody answered.

If I may make a suggestion. You really didn't define what you are trying to
do. Most of your wording (e.g. "else if") was about a way you are
thinking about solving it. You might want to repost accordingly.

Sincerely,

Fred

 

[BruceM]

I answered. Did that not show up in your newsreader?

I noticed that nobody answered.

If I may make a suggestion. You really didn't define what you are trying
to
do. Most of your wording (e.g. "else if") was about a way you are
thinking about solving it. You might want to repost accordingly.

Sincerely,

Fred

Hi! First of all i have 3 different colums in my form:- membershiptype[1
year
or 5 years] and employmentstatus[employed or unemployed] and membership
fees.

If i want to calculate membershipfees based on membershiptype and
employmentstatus:

If membershiptype = 1year and membershipstatus = unemployed then

membereshipfees = 5 else if

membershiptype = 1 year and membershipstatus = employed then

membershipfees = 10 else if

membershiptype = 5 years then

membershipfees = 70 . . . then return the value to my table. . .

Can anyone please help me on the formula for this. Thank you very much in
advance.

 

[vinchacho]

I noticed that nobody answered.

If I may make a suggestion. You really didn't define what you are trying to
do. Most of your wording (e.g. "else if") was about a way you are
thinking about solving it. You might want to repost accordingly.

Sincerely,

Fred

Hi! First of all i have 3 different colums in my form:- membershiptype[1 year
or 5 years] and employmentstatus[employed or unemployed] and membership fees.

If i want to calculate membershipfees based on membershiptype and
employmentstatus:

If membershiptype = 1year and membershipstatus = unemployed then

membereshipfees = 5 else if

membershiptype = 1 year and membershipstatus = employed then

membershipfees = 10 else if

membershiptype = 5 years then

membershipfees = 70 . . . then return the value to my table. . .

Can anyone please help me on the formula for this. Thank you very much in
advance.
Hi! Thanks again for your replies. What im trying to do here is to calculate what membershipfees will be based on what you select in the eploymentstatus and membershiptype fields on the form, and i also want to return the result to my table. Now that is just my explination as to how its supposed to happen. I don't know if anyone understands but any help will be extremely appreciated

 

[BruceM]

I noticed that nobody answered.

If I may make a suggestion. You really didn't define what you are trying
to
do. Most of your wording (e.g. "else if") was about a way you are
thinking about solving it. You might want to repost accordingly.

Sincerely,

Fred

Hi! First of all i have 3 different colums in my form:-
membershiptype[1 year
or 5 years] and employmentstatus[employed or unemployed] and membership
fees.

If i want to calculate membershipfees based on membershiptype and
employmentstatus:

If membershiptype = 1year and membershipstatus = unemployed then

membereshipfees = 5 else if

membershiptype = 1 year and membershipstatus = employed then

membershipfees = 10 else if

membershiptype = 5 years then

membershipfees = 70 . . . then return the value to my table. . .

Can anyone please help me on the formula for this. Thank you very much
in
advance.
Hi! Thanks again for your replies. What im trying to do here is to
calculate what membershipfees will be based on what you select in the
eploymentstatus and membershiptype fields on the form, and i also want to
return the result to my table. Now that is just my explination as to how
its supposed to happen. I don't know if anyone understands but any help
will be extremely appreciated

I described how to do this in my reply on 5/13. I can see my reply in my
newsreader, but it seems neither you nor Fred can.