Default Entry for a query

[Haas C]

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.

[chrisdavis]

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
Haas C wrote:

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.

[Haas C]

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.
chrisdavis wrote:

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
Haas C wrote:

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.