Help with Query

[Bell1991]

I have the following where clause:

Where
(( Forms!TestPage!numTotalMin is null or numTotal <= Forms!TestPage!numTotalMin) and (Forms!TestPage!numTotalMax is null or numTotal <= Forms!TestPage!numTotalMax ) )

This is returning all values in that range and null values? Is there a way to just return the values in the valid range (no nulls)??

Thanks

 

[traingamer]

Just take out the check for nulls if you don't want nulls.

 

[PHV]

WHERE numTotal Between Nz(Forms!TestPage!numTotalMin, numTotal) And Nz(Forms!TestPage!numTotalMax, numTotal)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244