OK Golom I read up on DateSerial(),
What an elegant solution! Thanks again.
Beginners, like me, may be interested in this explanation.
Select rDate,BYR,SSN
From Form100
Where rDate BETWEEN
DateSerial (StartYear, Val(Form.StartMonth), 1) AND
DateSerial (EndYear , Val(Form.EndMonth)+1, 0)...