Help with Access 97 Table

[sahotajaymin]

not to sure where i should post this, but here it goes...

I have an Access 97 table that shows a list of particular 'jobs' with
details
of when the unique job was ordered, when it was scheduled to ship, and
the date the job was billed (a.k.a. actual ship date)

What i am looking to do is determine the amount of time between the
order date, and schedule date, AND also determine the amount of time
between the scheduled date and the actual ship date.


All dates are in a 01/31/2006 date format.

Essentially i want to develop a measure of how correct the scheduled
ship date is to the actual ship date.

Can this be done in Microsoft Access? or would i have to export the
information into Microsoft Excel and finally how could i go about
accomplishing this task.


Thanks in advance

J

 

[ti976]

Yes,

pretty easy if all dates are in the same record. run a query with a
calculation field using the dates of that record - use datediff
function, ex.:

DateDiff("d", [OrderDate], [ShippedDate]), where "d" is the time unit
to calculate (d= days).

 

[Jams]

Thanks for your help, i'll give it a shot on monday.

J