Hi Guys
I am attempting to construct an if statement that will enable me to count all jobs between certain central London postcodes. The statement i have written is:
Global NumberVar EC1EC1 := EC1EC1+
(If ((Left({TableA.adad_postalcode},3) ="EC1") and {TableA.adad_addressnumber} = 0 )
and
((Left({TableA.adad_postalcode},3) ="EC2") and {TableA.adad_addressnumber} =1)
then 1
else 0);
If i only use the first line of the if statement it works fine. If i run
both lines then my result is 0 . I have a feeling that my brackets may not be right but i am not so sure.
The numbers means 1=collection 0= delivery.
I need to work out all collections from ec1 to ec1
ec1 to ec2
ec1 to ec3 etc.
EC1/2/3 are London postcode.
Any help would be appreciated.