[AccessD] Date Ranges

Paul,
you may want to download the Collision check from our website.
its just for such cases
Lembit

Lembit Soobik

----- Original Message ----- 
From: <paul.hartland at fsmail.net>
To: "accessd" <accessd at databaseadvisors.com>
Sent: Monday, July 12, 2004 12:47 PM
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