I want to enter a condition in the criteria of a query.

The condition is approx as follows:-

=>#01/04 (of the current year) and =<#31/05 (of the current year)

There is a reason for this, I want the query to be constant so I don,t have to re-design the query each year.

Can some-one help with the syntax

Dave

Between format("#01/04/" & year(date()) & "#") and format("#31/05/" & year(date()) & "#")