design advice

[Willy T]

I am trying to build a database that will measure
performance management in the delivery of a service
The table I have built so far allows the user to enter
times of events.
I need to measure the elapsed time between events and
compare elapsed times to target times
the events are
vehicle arrives
first delivery of x
last delivery of x
first delivery of y
last delivery of y

These deliveries need to be made within certain times
so I will need a report that will allow me to count all
deliveries = to or better than the target time for 1st X
then last X Then to count the occasions when both first
and last delivery of x met respective targets.

My existing table notes the events and times.
Do I need to have a table for target times or do I enter
the times in the criteria box in a query.
I actually want to be able to measure against the fixed
elapsed target times AND a measure against a time which I
can key in on the fly.
I realise this might cross over 2 discussion groups but
any advice would be appreciated

thanks Willy T

 

[Henry]

You can make it simple by puting it in one table. From what you described, it
is pretty simple.

You can build easy reports and forms based on queries to update, enter and
show whatever you want.

send me your database without any data in it, then I can be more specific.

Henry

 

[Will T]

Henry
Thanks for your offer,
I tried to send the db but it was returned ()as I
suspected) Is there an address to which it can be sent?
Regards Willy