Friday, December 12, 2008

problem solve

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: