Somebody help! on If...then, Else...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Somebody,
thanks if you could help me generate an expression to caculate values from
two fields whose answer will determine a value in another field.

an example is;
If Totals >70, then Grade=A
ElseIf Totals <=70, then Grade=B

Please, note that Totals is a calculated field.
 
calculated control on report or form
---

Hi Gorros,

is this on a report? a form? a query?

you can use IIF (immediate IF, all on one line) and you will have to
repeat the equation. For a report or form, this would be something like:

textbox controlsource --> =IIF(nz(sum([controlname]),0) >70, "A", "B")

and this would be in the same section as your calculation

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top