Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-27-2012, 07:40 AM   #1
naveen4pundir
Newly Registered User
 
Join Date: Apr 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
naveen4pundir is on a distinguished road
How to set call serial number according to call date and time

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.

naveen4pundir is offline   Reply With Quote
Old 04-27-2012, 09:25 AM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,253
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: How to set call serial number according to call date and time

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"?
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 04-28-2012, 04:07 AM   #3
naveen4pundir
Newly Registered User
 
Join Date: Apr 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
naveen4pundir is on a distinguished road
Re: How to set call serial number according to call date and time

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.

naveen4pundir is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Library of Congress Call Number Sorting akvbroek Tables 5 07-25-2009 04:31 AM
Call Call Audit_Trail Ambigious Error fenhow Modules & VBA 6 07-27-2007 08:26 AM
how to call a public function? call in a query? alienscript Queries 1 09-04-2004 06:49 AM
number of call per day by priority s0rtd General 1 05-02-2003 05:05 AM
Query to call out even number only..How? yughee Queries 1 04-29-2002 12:06 AM




All times are GMT -8. The time now is 10:08 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World