Group: microsoft.public.access.queries · Group Profile · Search for Datins in microsoft.public.access.queries
Author: Access101
Date: Sep 18, 2008 11:48
datin wrote: Hi, currently Im developing a database for HR.I need to display only child that will attend public examination in my report.Pls help me to solve this problem. Private Sub DOB_AfterUpdate() Dim age1 As String Me!Age = DateDiff("yyyy", DOB, Date) + Int(Format(DOB, "ddmm") Format(Date, "ddmm")) Refresh If Me!Age = 15 Then Me!Exam = "PMR" Else If
|