bound a year in a query 1

[gerard1979]

I need to track data with a query from 1-1-02 to 31-12-02, but it must be variable for the years, so next year its 1-1-03 to 31-12-03
What's the easiest way to bound a column on this criteria?

Thnx in advance,
gerard

 

[KenReay]

Hi

You can extract Year using Year() function, so if you have the query with a calculated column QYear:Year([datColumn]) and have a criteria on that column of (say) [Enter Year]. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[gerard1979]

As simple as efficient, so deserve the star. I like this forum!!