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?

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

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?

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

Alright thanks!