Date range return query

[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

 

[Allen Browne]

SELECT DateAdd("n", [num], [TheDate]) AS DateAndTime
FROM TblDates, TblMinPerDay
WHERE TblDates.TheDate Between [BeginDate] And [EndDate];