Thank you both. My colleague has also insisted that I use the parens and will from now on! Due to some testing I've done during the day I think TheBlondOne's statement in this case is very valid.
Hey there.
Sorry - should have mentioned that I had tried that already. Since my original query, however, I rearranged the formula within the SQL report and it seems to work now though I don't know why! If you can puzzle out why, I'd be grateful!
New formula...
Hi all,
I'm converting a crystal report from a pervasive database use to SQL database use. The below formula works fine in the pervasive report, but in SQL the report appears to have selected all the relevant records but only prints those that satisfy the first half of the query (everything...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.