Error Msg !!! Please help

[jai-cee]

Syntax Error (missing operator) in query expression 'IF(COURSE_WORK>80) : "90/100*500")'.

I am receiving that error message when applying filter.

Please anyone?

[orange]

What are you trying to do?
For If see http://www.techonthenet.com/access/f...ed/if_then.php

for iif see http://www.techonthenet.com/access/f...vanced/iif.php

[jai-cee]

I was trying to apply an If statement,

I basically want show criteria in the table

I can see it in the query, but I cant in the Table,
Please help me

[orange]

IF is a logic statement. You can use it in a query or program (procedure/function). It does not apply to a Table.

IF(COURSE_WORK>80) : "90/100*500")'

The syntax is incorrect:
-unbalanced parentheses
- unknown :
- quotes are used to delimit strings

The correct syntax and usage examples are shown in the links provide in previous post.

What exactly are you trying to do?
I'm trying to calculate......
I'm changing a value....
I'm trying to display..... ????

Perhaps you were thinking Validation:
See http://office.microsoft.com/en-us/ac...tedatainrecord