G
Guest
I have this Query:
Stud Name, Stud ID, EXAM, expr1=round(EXAM), expr2=10*EXAM-10*round(EXAM),
expr3=(exam with words)
I take from another table the exam degrre and i round it to take the 4 fe
if the exam deggre is 4,8. Then i do 10*EXAM-10*(round(EXAM)), to take the
eight. After all that i must write the name of the number so i write an
expression like that:
if ( exam2=1; "ena"; if(exam2=2; "dio"; ..... )) +if(exam3=1; " kai ena
dekato"; if(exam=2.....)). When i go to run the query i take the message "too
complex" or system resource exceeded. What can i do? I cant use VBA because i
must write the name of the numbers in greek and VBA doesnt write in greek.
What can i do?
Stud Name, Stud ID, EXAM, expr1=round(EXAM), expr2=10*EXAM-10*round(EXAM),
expr3=(exam with words)
I take from another table the exam degrre and i round it to take the 4 fe
if the exam deggre is 4,8. Then i do 10*EXAM-10*(round(EXAM)), to take the
eight. After all that i must write the name of the number so i write an
expression like that:
if ( exam2=1; "ena"; if(exam2=2; "dio"; ..... )) +if(exam3=1; " kai ena
dekato"; if(exam=2.....)). When i go to run the query i take the message "too
complex" or system resource exceeded. What can i do? I cant use VBA because i
must write the name of the numbers in greek and VBA doesnt write in greek.
What can i do?