search for: micromammiferes

Dear alls, Could someone tell me how to select a subset of string observations (e.g. "females" in a sex column) with sqlQuery in the RODBC library? Indeed, I'm trying to select a subset of observations on my access database with: female<-sqlQuery(mychannel,"SELECT Micromammiferes.sex FROM Micromammiferes WHERE (((Micromammiferes.sex)="females"));") The sql works well in access but in R, I keep getting: Error: syntax error. Any help would be very appreciated, Thanks a lot J??r??me Lema??tre Ph.D. student D??partment of biology, University Laval Quebec, Ca...