Appending individual dates using a date range

[The Colonel]

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.

 

[Tom van Stiphout]

On Tue, 8 Jul 2008 17:31:06 -0700, The Colonel

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

-Tom.