I've been asked to create a report based on certain tickboxes within our SQL database.
Here is the selection formula:
// Exclude Suspended clients and select client show receive a newsletter
({tblClient.Suspended} = FALSE and {tblClientExtraDetails.Newsletter} = "1")
and
// Show clients where Email_Moneyworks is EMPTY or FALSE
(ISNULL ({tblClientExtraDetails.Email_Moneyworks}) OR {tblClientExtraDetails.Email_Moneyworks} = false)
OR
// Show clients where Unsubscribe_Moneyworks is EMPTY or FALSE
(ISNULL ({tblClientExtraDetails.Unsubscribe_Moneyworks}) OR {tblClientExtraDetails.Unsubscribe_Moneyworks} = false)
Individually the Email_Moneyworks and the Unsubscribe_Moneyworks fields pick out 456 and 509 records respectively (with one or the other remm'd out).
However with both included I get 1463 results.
I'm suspecting it's either too many OR's for crystal to handle or my code is wrong somewhere.
The first criteria relating to suspended and newsletter must stay.
Any ideas much appreciated.
IP Logged
