Search results

  1. R

    How to make access record same date for different records, but with same reference?

    My problem: I got 2 suppliers to fulfill one order. Which means I have 2 Purchase Order numbers and one invoice number. When customer sends payment, I need to record the payment receive date against both Purchase Order numbers. Sometimes I can have lots of purchases to fulfill one order and I...
  2. R

    Multiple iif statements (at least 15)

    In my query, I have following fields: PayTerm, InvDate, DateMature, ETD, ETA, and DueDate. Base on the payment term, I'm trying to have database auto-calculate the Due Date in the query. Then update the due date in the table. The problem is that I have many payment terms. I try to fit them all...
Top Bottom