Here's a puzzle that has me stumped... (I have Alpha5 v9, Platinum, Desktop & Web Applications)
I am trying to build a Help Desk Ticket database that has a "unique reference number" which is automatically assigned to each record as the record is created. I understand how to put in an 'auto-increment' value in the field BUT I would like it to increment based on the date.
For example: If a record is being input today (19 Feb 2009) I would like it to look something like 20090219 (yyyymmdd) with an automatically generated "end" value of 001. In other words, the first record created for today would look like "20090219001." Then the second record created today would look like 20090219002. The third record 20090219003 and so on. And THEN as of 12:01am, on 20 Feb 2009, the first record created would look like 20090220001. The second record created (for the 20th) would look like 20090220002, and so on.
Right now I have this field set up as numeric; with a field length of 15 characters. Would it be a better idea to make it a character field?
I also have the idea of using a decimal place of 3 at the end of the field. So using the same example as above, the records would look like 20090219.001, 20090219.002 and 20090219.003.
Can anyone help me with this issue? It would be much appreciated. Thanx.
I am trying to build a Help Desk Ticket database that has a "unique reference number" which is automatically assigned to each record as the record is created. I understand how to put in an 'auto-increment' value in the field BUT I would like it to increment based on the date.
For example: If a record is being input today (19 Feb 2009) I would like it to look something like 20090219 (yyyymmdd) with an automatically generated "end" value of 001. In other words, the first record created for today would look like "20090219001." Then the second record created today would look like 20090219002. The third record 20090219003 and so on. And THEN as of 12:01am, on 20 Feb 2009, the first record created would look like 20090220001. The second record created (for the 20th) would look like 20090220002, and so on.
Right now I have this field set up as numeric; with a field length of 15 characters. Would it be a better idea to make it a character field?
I also have the idea of using a decimal place of 3 at the end of the field. So using the same example as above, the records would look like 20090219.001, 20090219.002 and 20090219.003.
Can anyone help me with this issue? It would be much appreciated. Thanx.
Comment