Recent content by ldare2000

I've changed interest rate to Percentage LOL

I think I've got it to work now..... but the maths is wrong. In my test: BalanceBeforeAnyPayments: -(FV([Monthly Interest Rate],[MonthsOfDebt],0,[Amount Borrowed],0)) Monthly Interest Rate is 0.4123, the MonthsOfDebt is 11 and the AmountBorrowed is 1000. However my calculation results...

Hi Can any one see what I've done wrong here: BalanceBeforeAnyPayments: (FV([Monthly Interest Rate],[MonthsOfDebt],0,[Amount Borrowed],0)) This lives in the Field now of a query? Can any one also confirm, the second section of date is for "Nper is the total number of payment periods in an...

Hi, Yes I think you're right. How could I create a Select Query to only return the highest bid? Thanks Louis

Hi, I'm really struggling with an A Level assignment. Would anyone be able to help? One table contains the following fields Bid Form Number (Key) Car Registration Number Trader Account Number Trader Bid Bid Date Bid Status Currently the first 5 fields are completed. There will only ever be...

WOW thanks :-)

Cool. One last one :-) I need to create a value based on todays date and the date an invoice was paid. But if the invoice is unpaid and the [Date Paid] is blank I need this days since paid to be 0 rather than blank. The following doesn't work but should give an idea to what I want to do...

I'm getting the correct value except it's coming out negative? Cheers Louis

Hi, One more quick one... Should this work in an Access form text box : =ROUNDDOWN([Days]/30) Thanks Louis

Thanks so much :-)

Hi, I've inserted a Text box and want to use the FV formula as I do in Excel is this possible? Acess doesn't like me inserting the following into the text box =FV(1%, [Text45],0,[Total],0) Thanks Louis

Hi, My name is Louis Dare, I teach IT however am a little rusty with regards to Access. I've done some Google searching and haven't found any applicable answers. To be honest this is a very simple database? Whenever I create databases I always get two pop up boxes on opening the mbd file...