yo, gud news=)
i finally succeed in writing codes for the calculated field that i dunno hw 2 do few days ago.
its simple.
Minutes: DateDiff("n", [StartDateTime], [EndDateTime])
"Minutes" is for the name of ur field in d query.
DateDiff() is the main code to calculate d field.
"n" is means minutes.
[StartDateTime], [EndDateTime] are the two fields that u wan to b calculated.
Of course, those codes can be even more complex for more complicated calculation.
I am learning them.. Well, I gt a long way to go=)
Bt all this hardwork pays off..
Honestly ms.access isn't user-friendly..hahax
No comments:
Post a Comment