computerfreaks
02-22-2002, 12:19 AM
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?
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?