I have a database that stores date-related records belonging to nuerous
employees. In some cases individual date entries are sufficient. In other
cases the data covers a span of time. I would like the user to be able to
simply enter a date range rather than having to do countless entries. How can
I extract and append each day's date to a table based on a specific date
range? The appended data should include both the start and end dates as well
as everything in between.

On Tue, 8 Jul 2008 17:31:06 -0700, The Colonel
<(E-Mail Removed)> wrote:

Write a query similar to this:
select * from SomeTable
where SomeDateField >= [Give start date:] and SomeDateField <= [Give
end date:]

-Tom.


>I have a database that stores date-related records belonging to nuerous
>employees. In some cases individual date entries are sufficient. In other
>cases the data covers a span of time. I would like the user to be able to
>simply enter a date range rather than having to do countless entries. How can
>I extract and append each day's date to a table based on a specific date
>range? The appended data should include both the start and end dates as well
>as everything in between.