How do I use TrueFalse function in the argument where for a query
Posted on 2004-08-03
I have a form where user can input restriction.
Like "show me date from XXXXXX(input) to XXXXXX(input) "
Then I use what's in the form to query the database (table transaction) with the where argument
In the creation view of the query, I would like to use the WHERE argument and put something like
Field : .Transaction.TransactionDate
Table : Transaction
Order : ASC
Show : No
Where : TrueFalse(Form![formname]![fromdate] Is Null;Display All;>=Form![formname]![fromdate]) AND TrueFalse(Form![formname]![todate] Is Null;Display All;<=Form![formname]![todate])
the default value of the field on the form is Null or "" or blank, I want the query to restrict to the input only if a value has been entered.
I have a number of input restriction but I just need to know the general idea of what it's suppose to look like.
Can someone help me with that?