Query to Parameter Query ?

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

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
 
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?
 

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

Similar Threads

Date range return query 1
Limit to Max Number 4
Very complex query 4
Modify Parameter Query 1
range of dates in a SQL query 3
Cross-tab to look like Calendar 1
Parameter Query 1
Reference a Date and Time in Query 2

Back
Top