Specifying Textual Criteria That Comes from a Field on a Form:

=DLookUp("[EMAIL]","penyelia","[NAMA PEGAWAI] = '" & [Forms]![borang]![NAMA PENYELIA] & "'")

Email – specific field

Penyelia – table

Nama penyelia – field yg berkaitan

Forms – berdasarkn borang

Borang – form name

Nama penyelia – field ygdiisi

=[nmPenyelia] & IIf(Nz([penyelia.EMAIL])<>""," [" & [penyelia.EMAIL] & "]")

TIMEDIFFERENCE IN ACCESS

Start time 01:10:53
Stop time 01:20:05
Duration IJAM, 40MINIT

USING DATEDIFF

EXAMPLE : Minutes: DateDiff("n",[STARTTIME],[STOPTIME])

DURATION: [Minutes]\60 & Format([Minutes] Mod 60,"""JAM,  ""00""MINIT""")