{?Start} <= {NVAPR.StartDate} and
{NVCasCat.Code}<>"C" and
{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and
{NVAPR.CaseType}<> (132) and
isnull ({NVAPR.SignOffDate})
and
(Isnull ({NVTresOf.Description})
or isnull ({NVActns.SystemKey})
or isnull ({NVActns.StartDate})
or isnull ({NVAPR.PlainEnquiry})
or isnull ({NVAPR.LocAddress1})
or isnull ({NVAPR.EnquiryType})
or isnull ({NVCasCat.Code}));
Thanks to help from forum members this report now works beautifully - BUT- I'd like to refine it still further and I'm not sure how to code the next step which needs an if statement adding I think.
I would still like it to pull out blank fields for NVActns.StartDate as above, but only if another field NVActns.ScheduleDate is also null.
The best I've come up with is below and I'm getting a type error message. I'm not surprised, logic is not my strong point!
{?Start} <= {NVAPR.StartDate} and
{NVCasCat.Code}<>"C" and
{NVApNoTy.Code}in ["AP","EPS","EWCL","FLYT","PC","PWS"] and
{NVAPR.CaseType}<> (132) and
isnull ({NVAPR.SignOffDate})
and
(Isnull ({NVTresOf.Description})
or isnull ({NVActns.SystemKey})
or isnull ({NVAPR.PlainEnquiry})
or isnull ({NVAPR.LocAddress1})
or isnull ({NVAPR.EnquiryType})
or isnull ({NVCasCat.Code})
*or if isnull({NVActns.StartDate})*
*and isnull ([NVActns.ScheduleDate});*
Your help on this will be appreciated.