Calculate days overdue for deliveries?

[Astrid]

Hello all, I'm hoping that you can help me out a bit. I'm using Access 2003,
and I would like to try to set up a query to calculate the days overdue that
regular shipments comes in.

As an add-on to our stock database, I have a table set up which we enter the
received date into. We know that different shipments are due on different
days (eg. 10th, 13th, 27th, and just for giggles some are weekly and some are
monthly). Is it possible to create a query which can calculate how many days
overdue a shipment is from its regular due date, without having to create an
'expected' date column and adding all the data manually each week?

I have used count tables before, but I had major problems with record
duplications, it got very complicated and to be honest I have very limited
knowledge of using VB, so I would like to avoid that option if possible.

I really need to get this sorted as we are having major problems with a few
of our suppliers being late and really having no continual record of how late
they are, so ultimatley I will create a report from this data so we can show
evidence to the board (and hopefully get new suppliers).

All help will be gratefully received.

 

[Jeff Boyce]

Astrid

The structure you provided certainly does look like a spreadsheet.

But Access is a relational database. If you try to feed it 'sheet data,
both you and Access will have to work much harder than if you feed it
well-normalized data.

Yes, you can just import an Excel spreadsheet ... no, it is NOT a good idea!

Regards

Jeff Boyce
Microsoft Office/Access MVP