Calculate the period in Access
-
Hi, I have an access database which contain one table with 3 fields. The structure below is:
tblPeriod Name DateHired DateRetired .... ......... ........... .... ......... ........... .... ......... ........... .... ......... ...........The ... represent the information of record that user supply the information. My question is: how could I calculate the period for each record (mean the duration that they work for the companay, simple arimathic is DateRetired - DateHired) in form. Which function should I used to calculate it? :confused:
A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office
-
Hi, I have an access database which contain one table with 3 fields. The structure below is:
tblPeriod Name DateHired DateRetired .... ......... ........... .... ......... ........... .... ......... ........... .... ......... ...........The ... represent the information of record that user supply the information. My question is: how could I calculate the period for each record (mean the duration that they work for the companay, simple arimathic is DateRetired - DateHired) in form. Which function should I used to calculate it? :confused:
A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office
I'm not aware of any function that would automatically do this for you. I think i've seen you post before using vb .net. But for either vb6, vba, vb .net you would have to create your own function that would take this. I use access in my apps, so i know some programming side, Again I don't know of any thing that will automatically take care of that.
-
I'm not aware of any function that would automatically do this for you. I think i've seen you post before using vb .net. But for either vb6, vba, vb .net you would have to create your own function that would take this. I use access in my apps, so i know some programming side, Again I don't know of any thing that will automatically take care of that.
I have check the book Visual Basic 5 Night School by Greg Perry and found the fuction to calculate the time
DateDiff(). I think this function might be useful for me to use in access but I did not try yet.
A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office