I'm creating a table where I import data from a csv file every day, one of the fields being a text version of a time duration for a task like "123:45" or "12:34". Being as I can't use this data form to calculate with or determine an average duration I decided to create a calculated field to give me decimal hours like 123.5 or 12.5
This screenshot shows how the calculated field is created (small pic?) but the calculation for Actual Hours is Left([Actual Duration],InStr(1,[Actual Duration],":",2)-1)+(1/(60/(Mid([Actual Duration],InStr(1,[Actual Duration],":",2)+1,2)+1)))
This was working fine on the day I did it, but since the database has been closed, it no longer imports the data and crashes Access instead! I've tried creating a copy of the table with empty data and it might work sometimes, but never once there's already data in the table. I've also tried a number of csv files from differing days, and they're all the same.
Without the calculated fields in the table, it will import any files I try, but the calculation works, so don't quite understand and I don't get any error messages.
Any thoughts?