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

  • Thread starter Thread starter gcp
  • Start date Start date
G

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
 
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.
 
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
Click to expand...

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.
 
Back
Top