1. time/date stamp as key & 2. total'g, av'g minutes & seconds

[gcp]

am abject beginner (Access 2000)w/two questions:
1. Want to use (automatically generated) time/date stamp
as primary key but find no info re how to create.
2. Need to take time segments (minutes & seconds)
previously generated by oversight program that watches
call-center agents response times, average, report them,
but have no luck trying to transform them to just seconds
and minutes w/o hours and "a.m./p.m." designation.
I am very grateful for any suggestions.
gcp

 

[Douglas J. Steele]

1. Create a Date field and set its default to =Now(). To be honest, I
wouldn't recommend using a timestamp alone as a primary key unless you're
positive that the values will be sufficiently infrequently that you won't
end up with duplicates.

2. Unless the time is text, you should be able to format it using nn:ss
am/pm. However, it sounds as though you actually want to do arithmetic with
the minutes and seconds. If that's the case, you'll probably need to use the
Minute and Second functions to retrieve those values, do your arithmetic,
then format it back.

 

[John Vinson]

am abject beginner (Access 2000)w/two questions:
1. Want to use (automatically generated) time/date stamp
as primary key but find no info re how to create.
2. Need to take time segments (minutes & seconds)
previously generated by oversight program that watches
call-center agents response times, average, report them,
but have no luck trying to transform them to just seconds
and minutes w/o hours and "a.m./p.m." designation.
I am very grateful for any suggestions.
gcp

Just to add to Douglas' excellent advice, consider using the
DateDiff() function to calculate the time elapsed between two
date/time fields. Open the VBA editor (by typing Ctrl-G) to load the
correct help file and look for help on DateDiff.