automate holiday periods (1 Viewer)

[SDB]

I have read more post than i care to think about but I can't stil get my head round the following problem.
I have created a database (with this forums help) but I am stuck on the following query/form/vba etc....

Our staff holidays run from 01/05/05 until 30/04/06 and i have a query that calculates what holiday entitlement staff are due from 01/05/05 on a daily basis up to 23 days worth of hols ending on 30/04/06, but I can't work out how to set next years holiday period 01/05/06 - 30/04/07 without changing the form manually, is there a way for it to auto update??

 

[SDB]

So its not only me who couldn't work this out, cheers for looking..

 

[Bat17]

If I was doing it I would probably use a field on the form to select the Year that you are intrested in and use dateserial() function to build the dates as a Between criteria in the query.

HTH

Peter