Query to Parameter Query ?

[D. Stacy]

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


I would like for this query to allow the user to select a data at runtime.

Can someone suggest how this query can be modified to achieve this goal?

The TblMinPerDay is just a numbers table 1 to 1440; the TblDates is just a
date data table.

Thanks

 

[KARL DEWEY]

I would like for this query to allow the user to select a data at runtime.
Do you mean Date?

I assume that [num] is from TblMinPerDay but what is the purpose of TblDates
in this query?