The above posters are correct. Resale value for almost all cars (the exception would be certain sports/exotic cars) are higher if they come with automatic transmissions...because 1) everyone drives auto's, and 2) usually auto's are more expensive to begin with (though not by much).

However, in the case of the Accord, I should think there are enough potential buyers that it really wouldn't matter significantly.