Joined: 05 Sep 2012
Location: United States
Online Status: Offline
Posts: 177
Posted: 01 Oct 2013 at 7:50am
it's my record select so in the formula there is
{co.co} = "company name" and {checkdate.startdate} = "01/01/2013" and {checkdate.enddate} = "09/26/2013" and {labor.detcode} IN ["401k", "403M", "403B", "403S", "L403B"]
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 01 Oct 2013 at 8:02am
and you have tested each of the values seperately to make sure that each one (not just one or two) gets the expected results?
I suspect that the either their is a join issue. if you can run it per value and get each to run correctly you (in theory) can use a parenthed OR statement, but there is no reason that should work over the IN statement.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 03 Oct 2013 at 4:59am
again my 2 cents...
have you tried breaking up the formula into smaller bits to 'debug' it...just to make sure that what you think is occurring, really is...
In it's own way, that is the most difficult part of report writing...since there is no stepping through the code, it's a black box and it either works or it doesn't...and when it doesn't it can be difficult to figure out why.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
