Search results

Hello all First off, love this forum.... has provided so much assistance for me in learning Access! I am having trouble writing a query to calculate the number of days between certain events. Currently i have a table set up that contains: tblMove Object Start Date Move Date Status (can be...

Hi Namilam PNGPorts is actually a work friend who helps me on these sort of projects from time to time. I fly back to work on Monday and can't wait to show her the solution you have come up with. I put the = back in and changed the table as suggested.... still works perfectly. Cheers mate!

Namilam You are a genius..... that query works exactly how i need it to!!!! Only had to change one thing slightly (removed a > from the formula as it was adding an extra day payment at the end of each demurrage range).... once i did this the query worked perfectly. Can't really express how...

Hi Namilam My DB is not used to raise any invoices.... i only need it to generate the figures so i can check them against the invoice that the shipping line provides. I will also use the DB so that i can watch and track my demurrage budget. The DB will also be linked to my other DB which...

G'day Namliam The demurrage is calculated for a calendar month period. So, lets use the example of a container that has been on site for 100 days, with demurrage charges commencing on 1st January. January invoice: elapsed days on site = 31 30 days x 0.00 1 day x $1.60 (so invoice total is...

Hi Dave That was quick. A bit of back ground..... i work at a gold mine looking after logistics on an island in the South Pacific region. All of the cargo we receive comes via ship and is stored in shipping containers. These containers are owned by the shipping lines, and we pay a demurrage...

Namilam Thank you very much for your help..... the query works perfectly! Also to Dave and Tim, appreciate your responses.... some more things for me to learn and research. Not coming from a back ground of programming and IT, i have to say that this forum has been a fantastic learning tool...

Hi Tim Thanks for your reply. I think i understand what you mean.... but still having trouble in working out how to express this in the query. This can still be done using the one single query? Cheers

First off - as my first post i want to say how good a forum this is. I have learnt so much from this forum, and there are quite a lot of knowledgeable posters!!! Anyway, resurrecting an old thread. Following the advice from Namliam, i have been able to create a query to calculate my demurrage...