Search results

  1. C

    Dateadd

    Thank you for you help think that works:)
  2. C

    Dateadd

    Hi Guys thanks for your reply I am new to entering code on access so if you could bear with me I would appreciate it. I've entered the code "Over Due: [DaysOverDue]=Date()-([InvoiceDate]+[Terms])" when |I run it the program asks for a parameter value days over due and a parameter...
  3. C

    Dateadd

    Hi Plog Thanks for your reply, the fields on my query are invoice date, payment terms, days over due. What I am trying to achieve is entering data into invoice date and then adding payment terms. From that point calculating the amount of days the payment is over due. I would have thought using...
  4. C

    Dateadd

    Hi can anyone help me with problem. I am trying to set up a query I need to use the current date but for checking on overdue payment of invoices plus the payment terms ie invoice date plus 30 days from the invoices date and then adding another days as the days role on I would appreciate it if...
Back
Top Bottom