Criteria help

computerfreaks

Registered User.
Local time
Today, 13:20
Joined
Jan 25, 2002
Messages
16
Hi, i need to know how I should set up my criteria. I want to create a report every half a year for the current data from January to July. I have two columns - date (of record) and year (of record).

For the year one I have set the criteria [Enter year], this gives the correct year as requested. I now need the date column to check for only ones between 01/01/year and 31/07/year

Have I done this a really silly way? how do I finish my criteria?
 
Criteria: Month(datevalue) < 8
 

Users who are viewing this thread

Back
Top Bottom