Can someone please help me! I want to compute in an Access database how many days an item has been in storage to appear in my Total days. These are my fields.
1. Arrival date =when the item arrived in storage
2. Dispatch date = when the Item was picked-up
3. Total days = The number of days an Item has been in storage before it was dispatch. If it has not been dispatched (dispatched date is blank) I want to compute today's date minus the arrival date.
Thank you
V/r
Rich

You might try:

=DateDiff("d", [OrderDate], [ShippedDate])

which should provide the difference as number of days.