469,156 Members | 2,152 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,156 developers. It's quick & easy.

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


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
1 1255
Jim Doherty
897 Expert 512MB
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.

Similar topics

reply views Thread by tukaram.thatikonda | last post: by
6 posts views Thread by Paula | last post: by
4 posts views Thread by Kory | last post: by
6 posts views Thread by guoqi zheng | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.