Set value if it is NULL in sql - Access 2007.

Question

Is it possible to set a value to values who is NULL?

The sql I use now is this:

SELECT date
FROM Activity
WHERE date BETWEEN [Forms]![Search]![fromDate] AND [Forms]![Search]![toDate]

But the problem is when there is no value for fromDate or toDate the result is zero rows. So what I want to do is when fromDate is NULL, change the fromDate value to 1800-01-01 and when toDate is NULL, change it to 2300-01-01.

Answer 1

You should be able to use the NZ function

Nz(variant [, valueifnull ] )

NZ link

Answer 2

Try this:

SELECT date  
FROM Activity
WHERE date BETWEEN 
    ISNULL([Forms]![Search]![fromDate], '1800-01-01') AND 
    ISNULL([Forms]![Search]![toDate], '2300-01-01')