Date range return query

  • Thread starter Thread starter D. Stacy
  • Start date Start date
D

D. Stacy

Here is my current Query:

SELECT (#10/15/2008#) + TimeSerial(0,[num],0) AS time_
FROM TblMinPerDay, TblDates;

The goal is to generate a list of time records in 1 min increments from
[BeginDate] to [EndDate]

The TblMinPerDay is a table of numbers from 1 to 1440
The TblDates is my table with data about dates from 1/1/1900 to 1/1/2076
 
SELECT DateAdd("n", [num], [TheDate]) AS DateAndTime
FROM TblDates, TblMinPerDay
WHERE TblDates.TheDate Between [BeginDate] And [EndDate];
 
Back
Top