anastasio86
Last Activity: Jun 2 '10, 08:46 PM
Joined: May 28 '10
Location:
-
i had tried your solution, and i tried again now. The problem is that if the user insert a value like #1/4/2009# for date1, the app takes the #1/1/2009# because of OR. It will work only whith an If, but i still haven't found that. Maybe with If and IsNull...Leave a comment:
-
anastasio86 started a topic How can a default value be inserted when running a query, enter no value?in AccessHow can a default value be inserted when running a query, enter no value?
Hi,
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? -
anastasio86 started a topic if i insert no value on a query, can the programme run with a default value?in Accessif i insert no value on a query, can the programme run with a default value?
I can't find how, on a query, the app insertes a default value when the user gives no value . for example: the app asks you to give a time period (from-to). if the user press "enter" it takes no value and shows nothing. Can, somehow, takes two default values, one for "from" and one for "to" ?
No activity results to display
Leave a comment: