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
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Somebody help! on If...,Then....ElseIf 4
IIf statement to show A, B, C 2
Enter Parameter Value in Access Form 0
Combining IF and VLOOKUP 2
Looking for Formula 1
Calculate current school grade level 2
If...then...else 4
Default Value on Form Help 1

Back
Top