Somebody help! on If...,Then....ElseIf

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gorros - 10 Mar 2007 17:17 GMT

'll be pleased if somebody could help me generate an expression or better
still a statement that will evaluate a value in a field and represent it with
a txt in another field.
Is thre a way out?

An example is;

If Totals >70, Then Grade=A
ElseIf Totals >60but<70 Grade=B
Else......till F.Where the options will end.

NB. Totals and Grade are fields on a query.
Thanks for helping.

Reply to this Message

Ofer Cohen - 10 Mar 2007 17:30 GMT

In the query create a new field, using IIf

Grade : IIf([Totals]>70,"A",IIf([Totals]>60,"B","C"))

Signature

Good Luck
BS"D

> 'll be pleased if somebody could help me generate an expression or better
> still a statement that will evaluate a value in a field and represent it with
[quoted text clipped - 9 lines]
> NB. Totals and Grade are fields on a query.
> Thanks for helping.

Reply to this Message

Gorros - 13 Mar 2007 19:10 GMT

Cohen,
that was just what i was looking for. am grateful, but you are great!
Nice Things! To HM also.

> In the query create a new field, using IIf
>
[quoted text clipped - 13 lines]
> > NB. Totals and Grade are fields on a query.
> > Thanks for helping.

Reply to this Message

MH - 10 Mar 2007 18:00 GMT

Use the SWITCH function:

SWITCH([Totals]>70,"A",[Totals]>60,"B",[Totals]>50,"C",[Totals]>40,"D")

etc.

MH

> 'll be pleased if somebody could help me generate an expression or better
> still a statement that will evaluate a value in a field and represent it
[quoted text clipped - 10 lines]
> NB. Totals and Grade are fields on a query.
> Thanks for helping.

Reply to this Message

Gorros - 13 Mar 2007 19:10 GMT

MH,
That was great you know?
Keep helping. am grateful. Stay kull

> Use the SWITCH function:
>
[quoted text clipped - 18 lines]
> > NB. Totals and Grade are fields on a query.
> > Thanks for helping.

Reply to this Message