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

Ive tried this but it still does'nt work properly, you see im bringing the Query into a crosstab Query and i taught if the above would work in 1 field in a query it would give me the answer im looking for If that makes sence :(

Hi KenHigg I already have these in a table, its called tblMPRN

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...

Ive tried this also and still nothing,,,, Ahhhhhh i dont know what im going to do now:mad::mad::mad: but Thanks for your help and patience all the same greatly appreciated

yes Non_Loss is a number field, I need to display the Non-Loss figures if the statement is true What I cant understand is this one works ISWT: IIf(([UOM_Code]='K3'),IIf([RegisterTypeCode]='IS' Or [RegisterTypeCode]='WT',[HHIntervalValue],"")) but the below doesnt ESonly...

Hi again Ive tried the aboue and even made the query smaller jus so I can see those ES figures and im still getting the same error

:eek: Oops im sorry for not formatting it,,,,ive alot to learn on this new site. ill check those errors out and ill let you know how i get on Thanks again

Hi Namliam and Thank you :) Heres the Crosstab Query (Its a big one) TRANSFORM Sum(qryevery30mins.[Non-Loss]) AS [SumOfNon-Loss] SELECT tblMPRN.CustName, qryevery30mins.MPRN, tblMPRN.MICKVA, tblMPRN.Contyp, tblMPRN.Duos, tblMPRN.Tuos, Sum(IIf(Weekday([Dte2]) Not In...

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...