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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gorros - 10 Mar 2007 17:05 GMT

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.

Reply to this Message

strive4peace - 10 Mar 2007 18:57 GMT

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
*

> Hi Somebody,
> thanks if you could help me generate an expression to caculate values from
[quoted text clipped - 5 lines]
>
> Please, note that Totals is a calculated field.

Reply to this Message