Search results

  1. K

    Calculating dates using IIF statement

    Hi, I am trying to calculate the date a shipment will arrive at site depending on if it goes by Ocean, Vessel, Air or Truck. I need to write a statement for a report that states something like: IIf [Planned MOT] like "Ocean" or "Vessel" Then [Site ETA] = [Forecast Ship Date] + 56 Else [Site...
  2. K

    Update table on Form Exit

    I have a form based on one table and I need it to update a different table on exit. I have tried some existing code in the data which I inherited from another programmer and am unable to make it work mostly because I don't really understand how the to write the SQL statement. What I need to...
  3. K

    Hello from Spring, Texas

    Hi, I'm Kathy and am relearning Access programming. I have not done this in years and now am faced with trying to remember things that I have long since forgotten and reverse engineer someone else's work. I consider myself new to this as it has been so long since I have done anything with...
Top Bottom