Search results

Hi Ive the below in a textbox on a report, its running fine, but im trying to add to it. Im trying to get it to count just one IN per day, if theres two or three IN's i want it to ignore it =Sum(IIf([Emp_Name]="INl",0,1)) Thanks

Hi Im struggling with trying to put the below into a query. Heres it in English Non Loss KWH: =IIf([MPRN]='81590699485' Or [MPRN]='81427150661' Or [MPRN]='81325023880' Or [MPRN]='81108542280' Or [MPRN]='81077371778' Or [MPRN]='81073326511' Or [MPRN]='81046871830' equals UOM_Code KWH and...

Hi folks I have the below into a crosstab (which is working fine) K3: IIf(([UOM_Code]='K3'),IIf([RegisterTypeCode]='IS' Or 'WT',[Non-Loss],"")) then ive ammended the same Query to look like this, so i will just see ES figures ESonly...