Search results

Hi...I have been using and modified slightly a sample accounting DB posted by Khawar which has been a great help, I have changed an SQL union query which brought together a client statement with a balance brought forward depending on date criteria selected ...this however is now not working...

Hi Gemma...many thanks for your well described musings :) I am at the moment trying to join as many of the calculated fields together as poss so as to limit the number of fields needed to create the final report..will post back how I get on...again thanks for your thoughts much...

Hi... I am trying to build a report for a life assurance illustration spanning 10 years with many variables building up the monthly totals and am only half way thru adding all the fields to the report and have got an error stating too many fields (over 255) by the end of the report I would need...

How do I PM one of the mederators ?? cheers Fi

Hi need a bit of urgent help, I posted a sample database while looking for some help, which I need to remove, coudl anyone please help me to do this the db contains company data...many thanks Fi

Hi Brian...thought that might be the case, unfortunately I dont have the Access knowledge to do the horrible IIf another way...you wouldnt happen to have a suggestion on how I could and then perhaps be able to set criteria on the date for the report ...cheers Fi

Hello again :) I have a report based on a query with a calculated date field, is it possible to use the Between And criteria on this field (when I try it asks for parameters FDOM, perpass, perpasm, periodlu) on the report NPD is set to short date format NPD: IIf([FDOW]<Date() And...

Hi..been off this 'project' for a few days thanks for your replies will look at them and post back...cheers Fi

the last one posted doesnt work correctly after further testing :( but I think this one does IIf([CSD]=Date() And [PP]=0,DateAdd("m",[period],[CSD] cheers Fi

Hi...ok get what you are saying, CSD of today is blank.....would this be close to the statement I need to fix it...(dont think so as this doesnt work :)) IIf([CSD]>Date(),0,DateAdd("m",[period],[CSD] cheers Fi had another try and think this is working IIf([CSD]=Date(),DateAdd("m",0,[CSD]

Hi..if the CSD turns out to be negative the calc uses PPM (CSD-Today) rather than PP (Today-CSD) making the NPD calc use a positive rather than negative for its calc, I need to see all NPD dates whether the CSD occurs in the past, present or future this calc for example gives me, Payment...

Hi namliam....thanks again for your help, I had this working from your previous post the problem is for future dated CSD's, which is what most will be when set up, in your example if we have Payment Frequency - Monthly Today - 16.01.09 CSD - 10.10.09 PP - 9 (not taking into account that the CSD...

Hi...they way I see it working is NextDueDate is calculated by looking at the PolicyStartDate the PmtFrequency and todays date it would need to calculate all possible NextDueDates that have occurred to date then display the next one dated after todays date which to me sounds like it needs a...

Hi...been at this all day and cant get my had round how to do it, self taught and it shows :) I dont understand what you are suggesting I do as how I understand what you are suggesting doesnt take into account dues dates in the future it will only give the first due date of the policy pmt...

Hi again...on your quote below wouldnt this only show the very first pmt date without taking into consideration that many pmt date could have passed since the start date....although i am probably not understanding what you are getting at :) 'I would probably put something like Where...

Hi..thanks for your reply, I am doing this which is giving the answer I need but I dont think it is the best way to do ...I could be wrong :) also it is ok for the Qtrly, Annual, biannual nextduedate calculation but when it comes to month there would be way too many IIf's this I hav set as the...

Hi...been searching posts and trying in vain to work through this but cant work out how to have the NextDate calculate by looking at the startdate then the policyperiod and be able to give a NextDate which is the next due date after todays date for that particular policy, possibly thinking about...

Hi..would you be able to expand on your reply ?? I think I need to increment the dates somehow as all i can get it to ...which is great...is give the next payment date based on start date ie if we look to the future and todays date is 3 months in the past, the monthly period, next pmt due would...

Hi namlian...your suggestion works great thank you very much....there had to be a question though ! we would have start dates in the future and it isnt working correctly, I have tried to change the calulation to incorporate this but have not managed to get it working....woudl you be kind ehough...

Hi namliam...looking at your suggestion now, will post back...with more questions no doubt :) cheers Fi