Search:

Thank you all !

* I gave a try to the distinct command, But it didnt work.

* about the other solution, I beleive that adding another Select within the existing one will slow the resalts (later...

hi
thank you all.


thanx susarlasireesha, I didn't try the order by max(grade)
didn't think it is possible.
this is what made it work. :-)


my problem now is that I have added one more...

hi
thank you!

why can't I sort it by the field of the grade?
(you gave me a solution to sort it by the name)

I added the Blue code but it wont work.

SELECT tblGrades.user,...

hello,

I have data that lookes like this:

user grade
------ ------
Adam 20
Adam 11
Adam 99
Roy 10

umm... ANYONE ?

I program in asp (isn't there a page here regarding plain asp?)

in my website, after a user creates an account i give the

session("_user_name_") = request.form("username")
so the user will...

hey, thank you !!
<br>
I am using access (I forgot to mention) but there is not much of a difference is it?
<br>
(Will I have to rewrite this sql when I will move it to msSql?)
<br><br>
here,...

hi
<br>
is there a way to merge two cols in to one?
<br>
<br>
this is how my data looks:
<br>
Name &nbsp;&nbsp;&nbsp;&nbsp; Second_Name
<br>...