Search results

  1. L

    Interest Calculation in Query returning #Error

    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...
  2. L

    Update Query based on highest bid????

    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...
  3. L

    Help needed with FV in form.

    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
  4. L

    Access 2003 Security Warnings

    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...
Back
Top Bottom