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