<P ID="edit" class=small>(Edited by teachesms on 06-Jul-05 14:15. SOLVED)</P>I am trying to do a BETWEEN/AND query using the month in this example as part of a Parameter query, allowing the user to type in for example Birthdates in the range of October (10) through December (12) as part of the parameter expression, of course they can change their input at any time, hense using the parameter query. The field is called [Birthdate]. Could you help me with the expression...nothings working this afternoon. Here is what I have on the criteria line below the [Birthdate] field, and it does give me the prompts for input, just no results:

I found this formula on http://www.fontstuff.com/access/acctut01.htm but it had only the option to use Month and Year...I want Month and Month from 10-12 for instance

Month([Birthdate])=[Choose a month from 1-12] And Year([Birthdate])=[Choose a month from 1-12]

Kept hunting on the sight listed above and found the formula I needed...hope it helps someone else...<img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Month([BirthDate]) Between [Start?] And [End?]

Thanks a bunch.