Parameter Queries w/ null parameters

[davidn]

I have a query which returns rows containing a column value matching a parameter. Query works now. I want to return all rows if the parameter is null. Anyone have an idea how to do this? I know it can be done, I just don't know how.

 

[gcole]

The simple way to do this is to use an if statement.
if parm = "" then
run this sql
else
run the other one
endif

 

[MichaelRed]

To really run the same one (reduces maintenance):

If (param = "") Then
[tab]parm = "*"
End If

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over