Search results

Hi CJ London Many thanks for your swift reply. Apologies for the delay in responding, but only just got back in front of a PC. The sort options for the database window in Access 2013 are:- - Name - Type - Created date - Modified date i.e. No "Description" ! Although it is a...

Hi Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances. Thankfully, "most" functionality appears to be working...

Hi Dave Thanks for the further feedback. I spent several weeks Googling around the subject, getting more and more confused, before deciding to post on here. Hopefully, my Accounts colleagues will finish their spot-sampling of the APR rates stated on old DD paperwork sometime this week. Once...

Hi Dave/ypma Dave - Many thanks for your input - we had "always been told" that 3% equated to 6.9% APR, so your doubling roughly accords. Unfortunately, "roughly" is not good enough - in the UK it is a legal requirement to state the equivalent APR for any financial product or offering (in...

Hi ypma Many thanks for your further reply. Apologies for the delay in getting back to you, but a combination of a family illness and numerous non-IT issues at work mean that I have not had a chance to look at this issue at all this week. I will download your sample database over the weekend...

Hi ypma Thanks once again for your most recent link. I have looked at literally dozens of different on-line calculators in doing my research and the only consistency seems to be that they all give different answers ! It's why I am so keen to get back to first principles - if I can get a...

Hi jdraw Many thanks for taking the time to reply too. I was aware of the Wikipedia page, but believe that the cited examples are 'probably' for the US version of APR. However, without references being quoted on that page, I am just presuming. Equally, the "European Union' section is a...

Hi ypma No problems, the fault is probably at my end. Sorry, but I am afraid that I cannot agree the APR. We have historically used a third party for our Direct Debit management/collection and have "always been told" that 3% equates to 6.9% APR - but they have been unable to provide any...

Hi ypma I have now had a chance to have a look at your sample database. Unfortunately, we appear to have been talking at cross-purposes. The Form that you have put together is absolutely fine, but the bit that I am struggling with is not actually shown on your form ! We will need to...

Hi ypma Many thanks for your further support. I'm currently on a PC with Access 2007, but should be able to jump on a box with Access 2010 later in the day. I'll post back once I have had a chance to look at your solution. Kind regards Horatio_too

Hi ypma Many thanks for your reply. Apologies for the delay in responding, but thanks to the weather I have spent no time in front of a PC for the last couple of days ! The best thing is to illustrate what we are planning to do with an example. Say the 'cash' price is £1,200. Without...

Hi I am in the process of adding the option to pay by Direct Debit (DD) to my existing Access 2003 line-of-business system. The business decision has been taken to make a small charge for paying using the DD facility (perhaps 3% ?) and I would appreciate some guidance as to how to calculate...