bergy
Posts: 14
|
| Posted: 11/21/2006, 9:37 PM |
|
Hi,
Something already post in the past but I didn't found any replies. So I adapted it to
my case.
I’m trying to add to a "search form" an option for whether a particular field (birth_date) is NULL or NOT NULL but I can’t figure out how to this.
The field birth_date is of type DATE.
The problem is that in msaccess this needs to be tested with “IS NULL” or “IS NOT NULL” and I need these to change dynamically according to the users’ choice in the search form.
What I’m trying to figure out is how to get the URL parameter to affect the condition field (IS NULL, IS NOT NULL) in the Data Source because the parameter field is ignored when these particular tests are performed.
I am using CC 3, PHP 5, msaccess
Thanks,
Stephan
|
 |
 |
|
