Flo this also worked great and in fact I did say I would want all records returned if no parameters were selected but in reality this would be probably crash...

Andrew, your WHERE clause worked a treat!

I will have to look into your T SQL suggestion as there will potential be 16,000 records a month being added to the...

Thanks for your reply Adi.

That makes more sense! The table is going to be huge so I will have to rethink it, starting with passing the parameters to a function...

sorry, forgot your last question. If all are null then all records will be returned. I have a default fromDate and toDate in the logged date parameter but it could...

It would be ok to select more than one pair so between logged dates and between paid dates may be selected.

both the from and and the to date of any...