Recent content by PNGPort

Thanks for the explanation. Have started redesigning the database with numeric primary keys.

Yes I agree the 255 characters was a bit excessive. And yes, if the date completed is filled then the job is complete. I'll update the database. I understand the "neatness" of using AutoNumber as a primary key but why wouldn't you use a field that is unique identifier for all of the...

What's girl suppose to do when a container ID is a mix of numbers and letters? :) Thanks for the explanation on why my query doesn't work. I've have a rethink on the design.

The record for container "Off Island", voyage 453 should not be showing a MEMRID as it doesn't have a matching record in tbleMEMRContainers. The records in this table for the container relate to the previous voyage (465). The DateRequested on the tbleMEMR must be between the import and export...

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

Thanks Namliam! It works brilliantly.

Sorry Bob. Here's the 2003 version of the database.

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