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

How can a default value be inserted when running a query, enter no value?

P: 4

I want to find the way to make a query that when the user runs it and enter no value, the applicacation inserts the default value. For example, the query asks to give a certain time period (From-To). If the user inserts no value, the programme returns the default period. Is it possible?
May 29 '10 #1
Share this Question
Share on Google+
1 Reply

Jim Doherty
Expert 100+
P: 897
May I suggest the you have a look at the general principle of "Query by Form" as it is generally referred to in Access.

You will get much more more control this way because you pass to the query the relevant parameters via control values on a form. You will have all the power of the forms underlying VBA at your fingertips to control what happens if a parameter value is empty and so on
May 30 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.