Criteria input format

[kidrobot]

I have the following query.

SELECT Table.*, Table.Date
FROM Table
WHERE (((Table.Date) Between [start date] And [end date]));

Is there anyway I can format the box that prompts you for the start and end dates? I would like the format to be, mm/dd/yyyy ? Any help?

 

[WayneRyan]

Kid,

I'd say that to gain control over the presentation of the request for
date(s) you'd be better off using an Access form. The query can use:

Forms![YourPopupForm]!StartDate

in its criteria fields.

It will also be available for display on any form/report that uses the
query.

Wayne

 

[kidrobot]

Wayne thanks for the suggestion! I actually first started out doing it like that, but the setup of my database doesn't conform well to that so I just changed it to open the parameter window. So other than an Access form is there any way to format the parameter window?

 

[boblarson]

...but the setup of my database doesn't conform well to that so I just changed it to open the parameter window.

Now that's a cryptic sentence...what do you mean? I would highly suggest using forms for input for all queries/reports as parameter input boxes do not give you any control over what's entered. There's no way to force a certain entry or anything. So, the answer is - either you go to a form so you can force certain actions, or you have to rely on the user typing the correct thing in the Input Box.

 

[kidrobot]

Alright thanks!