[AccessD] Date Ranges

Not enough, sorry, Doris.

Paul, what you need is this:

	start date between DateFrom and DateTo
OR	finish date between DateFrom and DateTo
OR	(start date before DateFrom AND finish date after DateTo)

HTH
John



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Mike & Doris Manning
> Sent: 12 July 2004 12:39
> To: 'Access Developers discussion and problem solving'
> 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
>