paul.hartland at fsmail.net
paul.hartland at fsmail.net
Mon Jul 12 07:18:20 CDT 2004
thats what I done but the start date for one of the records was before the start date required for the report and the finish date for the record was after the finish date required for the report, so I have had to also put for start date being before the startdate (report) AND finish date being after the finishdate (report) as well.... Thanks for help. I'm hoping this will solve it now Message date : Jul 12 2004, 12:39 PM >From : "Mike & Doris Manning" To : "'Access Developers discussion and problem solving'" Copy to : Subject : RE: [AccessD] Date Ranges Change your criteria so that you are pulling start dates between DateFrom and DateTo OR finish dates between DateFrom and DateTo. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Monday, July 12, 2004 6:47 AM To: accessd Subject: [AccessD] Date Ranges To all, Either I am getting too old for this programming lark or just can't seem to think anymore. We have a personnel & absence database from which we can pull off reports on certain date ranges. The problem I have is that one person was off from 16/06/04 and isn't due to return until 14/08/04. One of the HR girls entered the dates 27/06/04 as the start date for a report and 07/07/04 and a finish date for the report...and this person didn't appear on the records cause basically I have if the DateFrom in their absence record is greater than equal to the start date they enter and to DateTo in the absence record is less than or equal to the finish date for the report it gives those records. How would I take into account anyone that is off at any point between the startdate and finishdate that we enter for a report. Thanks in advance for all your help. Paul Hartland -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm