Date from Julian Day in text field

[kvest]

Hello,
I have a field (primary key- File Number) that is consists of the following characters >LA0000000a;;*. Counting from left to right, the first two letters (only one is required, indicate the area) the first two numbers indicate the year (yy) the next three numbers indicate the Julian day of that year. The last three numbers are sequential numbers not related to the date.

I have another field where the date that the incident occured on is entered. Since this data is already contained in the Julian information in the primary kay. How can I get this to be retrieved to eleminate a data entry step?

That database is up and worked very well with users having to enter this information by hand. I am trying to streamline things and cut data entry time. Currently 40-50 incidents are entered daily, but if this is implemeted at out other locations, that could climb into the 750-1000 volumne. All other locations would conform to this primary key field layout.

I am at the point that I know that Access can do pretty much anything, but figuring out how to get it to do it is beyond me.

 

[PHV]

Something like this ?
DateSerial(2000 + yy, 1, JulianDay)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244