Using OR to show all records if NULL criteria selected

[nandu]

I wonder if I have understood your requirement ! :(

I reckon you have complicated things a little.

Any way replace

AND CELLS.Zone = 'North East'

with

AND CELLS.Zone = nvl(combolist.value,CELLS.Zone)


HTH

- Nandu