Recent content by Andy__F

Hi Namliam The problem is my boss want all the occurrence for the next year in one report, not just the next one (at this stage I given up on the four month ones as there only 1 and just concentrated on the 6 and 12 months thus the two expressions which are in a query. The service Interval...

Sorry I should read my post more carefully !!! should read Expr1: Last([Date]+([ServiceInterval])*30) Expr2: Last([Date]+(([ServiceInterval]*2)*30) Service Interval is different for different customers The project is to list all our service in the next year, however this start from the...

Sorry the best I can get is the attached hope this helps !

Hi pr2-eugin Yea sure I have Customer IDCompany NameService IntervalLastOfDateExpr1Expr215401Mr Smith1203-Jun-0929/05/1024-May-11 and I would like Customer IDCompany NameService IntervalLastOfDate 15401Mr Smith1203-Jun-0929/05/1015401Mr Smith1203-Jun-0924/05/11 some how ! hope that helps

Hi all I have been banging my head into a brick wall with this one for ages but with out success so am after HELP !!!! Ok i have two column of expressions 1=(<(Now()+365)-([Service Interval]*30) Or <(Now()*365)-(([Service Interval]*2)*30)) 2= (<(Now()+365)-(([Service Interval]*2)*30) Or...