Hello all,
I need some advice and someone to point me in the right direction.
I have a table with a field in it that has text and a numeric value. For example, the field could have a combination of the following...
15 Mins
or
1.5 Hrs.
or
60mins
Although most of data in the fields will be like the first 2 options, the 3rd option could be there but really I am not too worried about those as they are few and far between.
Anyway, what I want to do is to make them all just a numeric value based on "minutes". So, I would like to strip the "Mins" away and just make it "15". or I would like to make "1.5 Hrs." be "90" (as in minutes). With a little bit of thought process I know that I can program some VBA to do this. The question that I have is what is the best way to go about doing this? Meaning, should I do a Make-Table? Update query? or something else? With any of these options, where would be the best place to place the code (once I write it)?
Thanks,
Stoss
I need some advice and someone to point me in the right direction.
I have a table with a field in it that has text and a numeric value. For example, the field could have a combination of the following...
15 Mins
or
1.5 Hrs.
or
60mins
Although most of data in the fields will be like the first 2 options, the 3rd option could be there but really I am not too worried about those as they are few and far between.
Anyway, what I want to do is to make them all just a numeric value based on "minutes". So, I would like to strip the "Mins" away and just make it "15". or I would like to make "1.5 Hrs." be "90" (as in minutes). With a little bit of thought process I know that I can program some VBA to do this. The question that I have is what is the best way to go about doing this? Meaning, should I do a Make-Table? Update query? or something else? With any of these options, where would be the best place to place the code (once I write it)?
Thanks,
Stoss
