Can I set a default value for a parameter query? 2

[Absalom]

Is there any way I can set a default value for the parameter part of a parameter query. If there was, then when a user left a parameter box empty there would still be the default value to fall back on.

Maintenance Planner in a Steel Mill

 

[PaulBricker]

Well, you can use an expression in the criteria line like this

[Enter Value] Or [Enter Value] Is Null

With this expression, if they don't enter a value then all the records are returned.

HTH

Paul

 

[dhookom]

You can use a criteria expression like:
Nz([Enter your favorite color],"Green&quot


Duane
MS Access MVP

 

[PaulBricker]

That's worth a star from me. Tried a few variations on that but didn't get it.

Paul

 

[Absalom]

Thanks dhookum,

The usage of Nz that you recommened works just fine for text but I couldn't get it to work for the date/time datatype. I tried each of the following. While I don't get an error, none of them returns any hits from the database.

Nz([Start Date],#1/1/2002#)
Nz([Start Date],"1/1/2002&quot
Nz([Start Date],1/1/2002)

Thanks

Maintenance Planner in a Steel Mill

 

[Absalom]

My Bad,

This statement actually works just fine if I include the correct operators.

Nz([Start Date],"1/1/2002&quot

should be

>=Nz([Start Date],"1/1/2002&quot

Maintenance Planner in a Steel Mill

 

[dhookom]

Actually you should probably use:
>=Nz([Start Date],#1/1/2002#)

Duane
MS Access MVP