Field is a reserved word. Should use a name other than Field.
Don't really understand the question - what do you want to change numbers to other than what you show in the expression?
There are fields named Computer, Maths, Statistics, Medical? Why does the average score determine which field value is displayed?
Switch() could be used instead of nested IIf
Switch([Expr1]>=80,[Computer]; [Expr1]>=70,[Maths]; [Expr1]>=60,[Statistics]; [Expr1]>=50,[Medical])
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you very much
What I want is
1. The user can change the names and numbers of the form of expression
2. Change (There are fields named Computer, Maths, Statistics, Medical? Why does the average score determine which field value is displayed?
) By the user
You want the user to control what is displayed and you want them to be able to set the group breaks?
Never seen anything like this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes
This is exactly what I want