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];

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question