Query criteria

[nicola1]

HI all,
i have a really annoying proble where the solution is probably staring me straight in the face. Basically i want to produce a report where the user is prompted to enter months to be looked at within a certain period and also the years, in my query i am using:

Between [First month] And [Last month]

and

Between [First year] And [to end year]

when i do this the query just asks for the months and doesnt go on to ask for the years...help?!

 

[ejstefl]

I'm a bit confused as to why you'd want to enter the month and year separately. If the user entered May for first month, August for Last month, 2001 for First year, and 2005 for end year, what results would you expect to see? May 2001 - August 2005? Any day that feel between May and August in the years 2001 - 2005?

Also, where do you have this criteria entered? On the same field?