Default Entry for a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Haas C - 16 Jan 2007 20:53 GMT

Hey all,

I created a Query which asks the user for an "As Of Date" which would
then display relevant data. Is there anyway to put in a default of
today's date in the input box and allow the user to change it to
whatever they want? Please let me know if this needs further
clarification. Thanks for all your help in advance.

Reply to this Message

chrisdavis - 16 Jan 2007 21:15 GMT

Hello..You can use the function called "now()" in the default value of
the text box and it will be today's date..you can go a step further and
use the format command: format([date],"mm/dd/yyyy" if you want or
whatever format you need.

HTH

> Hey all,
>
[quoted text clipped - 3 lines]
> whatever they want? Please let me know if this needs further
> clarification. Thanks for all your help in advance.

Reply to this Message

Haas C - 16 Jan 2007 23:36 GMT

Chris,

Thanks for replying to my post. However, I am a newbie when it comes to
this so can you tell me how to do what you've written below? I am using
the Design View for the Query and under the Date field, I have the
following entered in the Criteria row: <[Please enter As of Date]

Where can I find the default value of the text box?

Thanks in advance.

> Hello..You can use the function called "now()" in the default value of
> the text box and it will be today's date..you can go a step further and
[quoted text clipped - 9 lines]
> > whatever they want? Please let me know if this needs further
> > clarification. Thanks for all your help in advance.

Reply to this Message