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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top