[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