>>I already re-wrote it correctly for you. Why did you write it incorrectly again?
>
>Cause i had it before an when i used one "ON" it keeps tellin me not a character expression
Ok, fix the query first the way I wrote it.
If it's not broken, fix it until it is.
My Blog 
