Newbies cmonroe11 Posted November 21, 2000 Newbies Posted November 21, 2000 Hello Everyone, I need to keep track of a user's call with a call #. Rather than use the "serial number" implementation, I would like to use the date plus an incremental # to keep track of each call every time a new record is created( e.g. 112120001, 112120002, etc.) I hope this is clear.. thank you in advance
LiveOak Posted November 21, 2000 Posted November 21, 2000 First, go ahead and create a serial field, call it Serial#. Then create a field based upon it as follows: Call# (calculation, text, stored) = Right("0" & Month(Status(CurrentDate)), 2) & Right("0" & Day(Status(CurrentDate)), 2) & Year(Status(CurrentDate)) & Serial# The reason I padded out the month and day is that: 11/1/2000 --> 1112000 1/11/2000 --> 1112000 Oops! The running serial number would still make the resulting call numbers unique, but if you just used the date, you could have a problem! This is one of those easy problems that is hard to debug, if you have used a composite key to connect two related files. -bd [This message has been edited by LiveOak (edited November 21, 2000).]
Recommended Posts
This topic is 8754 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now