How to set call serial number according to call date and time (1 Viewer)

naveen4pundir

New member
Local time
Today, 23:36
Joined
Apr 27, 2012
Messages
2
Dear all,
i Have some customers call details and i want to set serial number in front of it. in excel it is possible with some formula but in access how it will done.
example is below mention..

Caller Number Called Number Time Stamp Count
97444477100 97317317312 4/15/2012 20:09 1
97444477100 97317317323 4/15/2012 20:47 2
97444477100 97317317315 4/15/2012 20:55 3
97444477100 97317317319 4/15/2012 20:57 4
97444477134 97317317312 4/15/2012 20:57 1
97444477134 97317317312 4/15/2012 21:26 2
97444477134 97317317312 4/15/2012 21:29 3
97444477134 97317317356 4/15/2012 21:31 4
97444477134 97317317356 4/15/2012 21:37 5
97444477134 97317317356 4/15/2012 21:37 6
97444477174 97317317311 4/15/2012 21:37 1
97444477174 97317317311 4/15/2012 21:43 2
97444477174 97317317334 4/15/2012 21:44 3
97444477174 97317317334 4/15/2012 21:52 4
97444477174 97317317334 4/15/2012 21:55 5
97444477174 97317317321 4/15/2012 22:34 6
97444477174 97317317321 4/15/2012 22:38 7
97444477177 97317317317 4/15/2012 22:17 1
97444477177 97317317317 4/15/2012 22:39 2
97444477177 97317317317 4/15/2012 23:06 3

Thanx in advanced.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 15:36
Joined
Feb 19, 2002
Messages
43,231
Welcome aboard:)
If your data was loaded into the table in timestamp order, adding an autonumber column will give you a "serial number". Just keep in mind that you will have gaps if you delete records.
What is the purpose of the "serial number"?
 

naveen4pundir

New member
Local time
Today, 23:36
Joined
Apr 27, 2012
Messages
2
hi, thanks for responding.

actually this serial number is basically call number. after putting this if i want to see that these customer made first call to which number or what is the 2nd,3rd ...n called number i can see easily.
 

Users who are viewing this thread

Top Bottom