Sorry Grnzbra, forget the original quote, my problem has changed here
I'm trying to return a value in the text box which is <>"LOANS" and <>"RENTS". the query then uses this text box as a parameter but it must be treating it as one single text block because it returns no rows at all!
I've...