Home Forums SQL Server 2008 SQL Server Newbies Expression assistance required please RE: Expression assistance required please
faulknerwilliam2
SSCrazy
Points: 2299
More actions
November 10, 2014 at 1:02 pm
#1757542
Thanks for taking the trouble to reply.
Will bear in mind for next time, thanks. In the end I solved this knotty conundrum via:
=Sum(Iif(Fields!transactiontime.Value = 0, 1, 0))
Which worked like a dream.