Recent content by Tajaldeen

Non of these functions has worked at all

I'm using this code to stop banker's rounding but it's not perfect so far Round(Int((([FieldName]+0.499)*2)/2) Does anyone has more efficient way to make normal rounding such the one on Excel.

Amazing .... thank you very very very much, you just solved a big problem. where there is a will , there is a way.

Hi Guys, I have a table with three fields: ID, Name, Mark i also have created the following Query which ranks students in the table based on Mark SELECT T2.Name, 1+(SELECT COUNT(T1.Mark) FROM [Table] AS T1 WHERE T1.Mark >T2.Mark) AS Rank FROM [Table] AS T2 ORDER BY T2.Mark DESC; the problem: if...