How to modify query criteria for ranges?

[cykchanaa]

I currently have a query that references controls from my "Main" form using the criteria below.



Between [Forms]![Main]![Minarea].[Value] And [Forms]![Main]![Maxarea].[Value] Or [Forms]![Main]![Minarea].[Value] Is Null Or [Forms]![Main]![Maxarea].[Value] Is Null

I would like to make this criteria work even if I leave one of the boxes empty. For example if Minarea is 10 then I would get all the results greater than 10 even if Maxarea was left empty and vice versa. Currently the query requires both boxes to be filled to run.

Thanks in advance.

[June7]

Can assign an alternate parameter that the data cannot possibly be outside of.

Between Nz([Forms]![Main]![Minarea],0) AND Nz([Forms]![Main]![Maxarea],99999)

However, I never use dynamic parameterized queries. I prefer: http://www.allenbrowne.com/ser-62.html