Simple (()) issue

[Tekhelpnet]

Can someone see what is wrong witht his formula?
IIF(ISNUll([GRADE_FROM], [GRADE_TO], [GRADE_FROM] & " - " & [GRADE_TO])
OR
IIF(ISNUll([GRADE_TO] , [GRADE_FROM], [GRADE_FROM] & " - " & [GRADE_TO])

Thanks

 

[MajP]

I count three ")", never a good sign. isnull([Grade_To])

 

[traingamer]

IIF(ISNUll([GRADE_FROM][COLOR=red][b])[/b][/color], [GRADE_TO], [GRADE_FROM] & " - " & [GRADE_TO])

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[traingamer]

late again

 

[Tekhelpnet]

Am I blind? Let's see...Oh! I see thanks!
However it doesn't work yet...

IIF(ISNUll([GRADE_FROM]), [GRADE_TO], [GRADE_FROM]
& " - " & [GRADE_TO])
OR

IIF(ISNUll([GRADE_TO]) , [GRADE_FROM], [GRADE_FROM]
& " - " & [GRADE_TO])
NO LUCK with
IIF(ISNUll([GRADE_FROM]), [GRADE_TO], [GRADE_FROM] & " - " & [GRADE_TO])
OR
IIF(ISNUll([GRADE_TO]) , [GRADE_FROM], [GRADE_FROM] & " - " & [GRADE_TO])

 

[Tekhelpnet]

Had changed it - error anyway:
=(IIf(IsNull([GRADE_FROM]),[GRADE_TO],[GRADE_FROM])) & " - " & (IIf(IsNull([GRADE_TO]),[GRADE_FROM],[GRADE_TO]))

 

[genomon]

=IIf(IsNull([GRADE_FROM]),[GRADE_TO],[GRADE_FROM])) & " - " & IIf(IsNull([GRADE_TO]),[GRADE_FROM],[GRADE_TO]))

The early bird may get the worm, but the second mouse gets the cheese in the trap.

 

[Tekhelpnet]

tOO MANY CLOSING PARENTESSES EROOR! tHANKS AND SORRY

 

[genomon]

OOPS

=IIf(IsNull([GRADE_FROM]),[GRADE_TO],[GRADE_FROM]) & " - " & IIf(IsNull([GRADE_TO]),[GRADE_FROM],[GRADE_TO])

The early bird may get the worm, but the second mouse gets the cheese in the trap.

 

[Tekhelpnet]

WHYWHYWHY it showing #error????????

Thanks for trying!

 

[genomon]

Sheesh! #error is usually caused by mis-spelled field names (sometimes I even find that I spelled the field on the table something different than I remember), or datatype mismatch. How frustrating!!!





The early bird may get the worm, but the second mouse gets the cheese in the trap.

 

[Tekhelpnet]

I am actually selecting the name from the drop down menu.
:-(

 

[Tekhelpnet]

You wanna laugh?
I took out = and it works a charm!
Thanks and please, comment if you wish!

 

[genomon]

Cool - this Bud's for you!


The early bird may get the worm, but the second mouse gets the cheese in the trap.

 

[Tekhelpnet]

HAHAHA! Thanks. With pleasure!

 

[PHV]

A simpler way:
Nz([GRADE_FROM],[GRADE_TO]) & " - " & Nz([GRADE_TO],[GRADE_FROM])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886