Recent content by yyyoong

If i have a number and i try to use this expression to truncate the number (with 2 decimal places)in the query, but it doesn't work, can anyone please help me ? TRUNC(number, 2)

median value Thanks to Jon K, by reading the attachment, i have an idea on how to do it.

To find median value Thanks for showing the syntax, but i tried it in the queries, but it can't work. Actually my problem is: I have 4 fields (columns) in the queries, and intend to find the median values from the 4 columns, can i use the vb code in the 5th column in the queries?

Can anyone please help me to find the median values of 4 numbers given ?

If I have 4 columns in the queries, and intend to find the median value of these 4 columns, can any one help me in the syntax, cos' I tried to use median (C1, C2, C3, C4), but it couldn't work.

I 'm trying to use dlookup table in my queries, but can't work it out, can anybody help me ? can I use Queries! for active query ? What's wrong with the expression below: Dlookup ("[grade]", "[grading]", "[Expr1]= Queries![Expr1]") i intend to look up the values in the "grade" field in the...

Can someone please help to solve this querry, i wish to work out an aotomatic grading system for exam, the conditions are shown below, but i'm not sure of the syntex. if there are 2 papers, paper 1 and Paper 2, if the average of both papers added are more than 4o marks, it should be given an E...