Display all results if parameter is blank

[justifiedcandy]

Hi-


I'm trying to create a query on a column with only numbers. When I leave the parameter blank, no results show. I would like all results to show if the parameter is left blank. This is the code I'm using:

Between [Minimum Number] And [Maximum Number]

Thanks!

[weekend00]

(fieldName >=[Minimum Number] or [minimum number] is null ) And (fieldname<=[Maximum Number] or [maximum number] is null)

[justifiedcandy]

thanks, works!