Search results

  1. P

    Removing duplicate records in query

    I’m trying to write a query that shows all the container movements. Yet when I run the query “qryFullHistory” I get a duplicate value for container “Off Island”. I’ve tried adding some criteria that says that the DateRequested has to be between the ImportDate and ExportDate but that doesn’t...
  2. P

    Demurrage Calculation using a sliding scale

    I’m trying to build a database to calculate the demurrage on containers. The demurrage is determined by the container owner, the container type and the number of days that it is in use. I’ve calculated the number of days that it is in use in ElapsedDays query as well as collated the other...
Back
Top Bottom