G
Guest
i have several queries which have a date range as a filter (between dates) eg
i put in on a form start date: 21 nov 05 and end date 20 nov 06 and the query
filters out all other records.
what im having to do is each year, alter the dates to the current year. eg
business year starts 01 jan 05 ends 31 dec 06.
Does some one know some code where i can just type in 01 jan and 31 dec
without putting in the year and every year the year updating automatically
i put in on a form start date: 21 nov 05 and end date 20 nov 06 and the query
filters out all other records.
what im having to do is each year, alter the dates to the current year. eg
business year starts 01 jan 05 ends 31 dec 06.
Does some one know some code where i can just type in 01 jan and 31 dec
without putting in the year and every year the year updating automatically