Calculate Report Value

[elead]

Below is a calculated field formula from a crystal report.
I need to accomplish the same thin in Access. I was wondering if someone could show how it would be constructed in an MSAccess report calculation--Thanks

If {tblAgentTotals.Total_HFPCT} >= 0.275 And {tblAgentTotals.Total_HFPCT} <=0.349 AND {tblAgentTotals.Top25}=25 AND {tblAgentTotals.Total_HF} > 30 Then
20

Else {tblAgentTotals.Total_HFPCT} >= 0.275 And {tblAgentTotals.Total_HFPCT} <=0.349 AND {tblAgentTotals.Top50}=50 AND {tblAgentTotals.Total_HF} > 30 Then
15

Else {tblAgentTotals.Total_HFPCT} >= 0.275 And {tblAgentTotals.Total_HFPCT} <=0.349 AND {tblAgentTotals.Total_HF} > 30 Then
10

Else If {tblAgentTotals.Total_HFPCT} >=0.35 AND {tblAgentTotals.Top25}=25 AND {tblAgentTotals.Total_HF} > 30 Then
30

Else If {tblAgentTotals.Total_HFPCT} >=0.35 AND {tblAgentTotals.Top50}=50 AND {tblAgentTotals.Total_HF} > 30 Then
22.50

Else If {tblAgentTotals.Total_HFPCT} >=0.35 AND {tblAgentTotals.Total_HF} > 30 Then
15

 

[braindead2]

Look at the switch or IIF functions in access help