Making a Parameter Query for Date and timestamp, with input mask.

D

Dan

I am not sure if this is easy or hard, but hope someone can help. I have a
Query that I am trying to build for my end users. I need under the timstamp
feild a Parameter that they would be able to input a start and end timestamp
as to run the query for a specific time frame, I was also hoping to limit the
characters lik an input mask so they wouldn't be able to type in the format
inccorectly. An example of the data is I need them to be able to enter
something similar to this.
Date: Between 2007-01-01-00.00.00.00000 And 2007-01-02-00.00.00.000000, with
the input mask limiting them to those feilds and dashes and periods already
in place. Is this possible?
 
D

Douglas J. Steele

You can't control pop-up parameters in any way.

One option you have is to open a form, and have appropriate controls on that
form. In the query, refer to the form controls (as
Forms![NameOfForm]![NameOfControl]). Add a command button to the form that
launches the 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

Top