By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

Default Entry for a query

P: n/a
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.

Jan 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Jan 16 '07 #2

P: n/a
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.
Jan 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.