Reporting Time fixed as a daily variable

[jalal]

Hi
Please help
I am working on office database. I have to note the fixed reporting time of every employee on a daily basis at 9:50 AM. That is the 9:50Am is the reporting time (ArrivalTime). If any employee attends the office at 9:51am a flag is incerted as “Late”.

However, The employee is give a benefit for ten mintus. i.e. he can mark the attendance upto 10Am but will be treated as late comer. After 10 am a flag is created as and a late mark (1) is generated. The late marks are counted during the month and and 6 late marks will penelize the employee as ½ days leave.

Now I want to generate a control which will give 9:50 Am as reporting time every day.


I have already used the following formula but trhe problem is it gives me reporting time as 10 Am.
instead I want 9:50 am as reporting time

Formulla which I used in the query >>> field 1 = ArrivalTime & field 2 = ReportingTime

Arrivaltime : date()
ReportTime: DateAdd("h",+10,[ArrivalTime])

Rest of the Flags I have already generated

Thank You
Jala

[June7]

You are adding 10 hours to the Date()

Try:
ReportTime: CDate(Date() & " 9:50:00 AM")

[jalal]

Thanks for helping
Problem solved