Hello, here is my senerio: I have a database that is to be used for employee scheduling. I want to create a report that shows employee time by day, month, and year and time usage. For example, sick leave, vacation, scheduled. I have a lookup table for types of time usage. The user enters the time type from a combo box on an entry form. The report is based on a query. The problem I am having is putting hours in the correct time category.
Annette Towner
2002 Day Vac. Sick Comp. Time Unpaid Leave Floating Holiday
5
1 8.00
9 1.00
10 3.00
13 3.00
In the above May 1 and 9 should line up under the vac label and 10 and 13 under the sick label.
In my query I tried to accomplish this by creating an expression as follows: Expr4: DLookUp("[Total Hours]","[Leave Request]","
Annette Towner
2002 Day Vac. Sick Comp. Time Unpaid Leave Floating Holiday
5
1 8.00
9 1.00
10 3.00
13 3.00
In the above May 1 and 9 should line up under the vac label and 10 and 13 under the sick label.
In my query I tried to accomplish this by creating an expression as follows: Expr4: DLookUp("[Total Hours]","[Leave Request]","
Code:
= 'vacation'") When I run the query this column is blank.
Any help would be greatly appreciated.
P.S. A double star for anyone who can tell me how to convert the 5 into May.