date and case calculation

[cmonroe11]

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]

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).]