Have a similar problem on the right front passenger door on my 2002. Occaisionally (over the past year +), it appears DOA. Get out of the car, open and slam the door shut, and it works fine. Suspect a bad electrical connection to the motor.
yeah i can hear the clicking, then the window worked again this morning, im gonna try to lube it while its still working again so it can be worked in i geuss, if not ill just get a new motor/mechanism, its not worth the aggravation with it only working when it feels like it.