Updating time fields

[Guest]

I work for a medium sized college's security deparment
all deparments use radios and comunicate via a central dispatcher
when the call dispatch they enter their radio call into an accses database
that i have now inharited.

what we need it to do now, in addition to what it already does, (track radio
trafic date and time entered) is to also track the time between radio calls
(want us to know where everybody is. so we need to make sure they are calling
in every 20mins)

The radio trafic table is simple

it consists of an autonumber field (P-Key), text fields for
location,callsign,code,building, a memo field for notes, and a date/time
fields for date, time, time of last call, time differential

what i need is to update the time of last call field, with the time of their
last call
then update the time diferential by subtraction last call from the time feild

what i am not sure how to do is to update that last call feild from the last
call of that perticular person
right now all i can get is the last call entered in the system

the other bit once i have the last call i can run an update query to change
the time differential query

 

[Marshall Barton]

I work for a medium sized college's security deparment
all deparments use radios and comunicate via a central dispatcher
when the call dispatch they enter their radio call into an accses database
that i have now inharited.

what we need it to do now, in addition to what it already does, (track radio
trafic date and time entered) is to also track the time between radio calls
(want us to know where everybody is. so we need to make sure they are calling
in every 20mins)

The radio trafic table is simple

it consists of an autonumber field (P-Key), text fields for
location,callsign,code,building, a memo field for notes, and a date/time
fields for date, time, time of last call, time differential

what i need is to update the time of last call field, with the time of their
last call
then update the time diferential by subtraction last call from the time feild

what i am not sure how to do is to update that last call feild from the last
call of that perticular person
right now all i can get is the last call entered in the system

the other bit once i have the last call i can run an update query to change
the time differential query

You should not put data like time of last call and time
differential in a table because those values can easily be
recalculated any time you want to display them on a form or
report.

A text box can display the last call time by using an
expression like:
=DMax("[call time field]", 'radio trafic", "callsign="""" &
callsign)

Then the tme differential text box can calculate the number
of minutes using:
=DateDiff("n", [last call time text box], [call time field])

 

[Pete]

You can use a program called, scanner Recorder Setup.msi and Itracker to
record this info into text files that can be imported into access. Id
tracker records radio info, time date. Recorder pulls in the whole
conversation when radio is transmitting. Together you can index all
transmissions to the radio, time, date, and a recording of the transmission.
Ask a computer professor and with access you will exceed many police
departments. Mine is about 50% complete to put it all together in access.
Not enough hours in the day. Duff

I work for a medium sized college's security deparment
all deparments use radios and comunicate via a central dispatcher
when the call dispatch they enter their radio call into an accses database
that i have now inharited.

what we need it to do now, in addition to what it already does, (track
radio
trafic date and time entered) is to also track the time between radio
calls
(want us to know where everybody is. so we need to make sure they are
calling
in every 20mins)

The radio trafic table is simple

it consists of an autonumber field (P-Key), text fields for
location,callsign,code,building, a memo field for notes, and a date/time
fields for date, time, time of last call, time differential

what i need is to update the time of last call field, with the time of
their
last call
then update the time diferential by subtraction last call from the time
feild

what i am not sure how to do is to update that last call feild from the
last
call of that perticular person
right now all i can get is the last call entered in the system

the other bit once i have the last call i can run an update query to
change
the time differential query

You should not put data like time of last call and time
differential in a table because those values can easily be
recalculated any time you want to display them on a form or
report.

A text box can display the last call time by using an
expression like:
=DMax("[call time field]", 'radio trafic", "callsign="""" &
callsign)

Then the tme differential text box can calculate the number
of minutes using:
=DateDiff("n", [last call time text box], [call time field])