Howdy,
Not sure if this should go in this forum or the reports one but here goes.
I am designing a training records database and one of the things that needs to be recorded is the date a course was completed. These should then be displayed in date order on a report. The problem i've got is that the dates I have been given from the current paper based record system are in 3 different formats. They are either 'short date', 'medium date' or just the year. Is it possible to store these values as one of the 3 formats in one field ??
At the moment i've got another field as autonumber. The records are sorted on this field but this means that the training records must be entered into the database in date order starting with the earliest so they appear in the correct order on the report. As i'm sure you can imaging, this is far from ideal.
Hope someone can offer some assistance with this matter. I'm really looking forward to getting this database completed and I think this is going to be my last big hurdle.
Thanks in advance
TSSTechie
May The Force Be With You
![[yoda] [yoda] [yoda]](/data/assets/smilies/yoda.gif)
Not sure if this should go in this forum or the reports one but here goes.
I am designing a training records database and one of the things that needs to be recorded is the date a course was completed. These should then be displayed in date order on a report. The problem i've got is that the dates I have been given from the current paper based record system are in 3 different formats. They are either 'short date', 'medium date' or just the year. Is it possible to store these values as one of the 3 formats in one field ??
At the moment i've got another field as autonumber. The records are sorted on this field but this means that the training records must be entered into the database in date order starting with the earliest so they appear in the correct order on the report. As i'm sure you can imaging, this is far from ideal.
Hope someone can offer some assistance with this matter. I'm really looking forward to getting this database completed and I think this is going to be my last big hurdle.
Thanks in advance
TSSTechie
![[lightsaber] [lightsaber] [lightsaber]](/data/assets/smilies/lightsaber.gif)
![[trooper] [trooper] [trooper]](/data/assets/smilies/trooper.gif)
![[yoda] [yoda] [yoda]](/data/assets/smilies/yoda.gif)