The president's overall approval rating has dropped ahead of the midterm elections in November.