Appending individual dates using a date range

  • Thread starter Thread starter The Colonel
  • Start date Start date
T

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.
 
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.
 
Back
Top