T
TeeDee
I have a form text box that needs to be based on three
criterias, If field one equals criteria value would be O/D1
stop, if not go to field two, if meets criteria value would
= O/D2 stop, if not go to field 3, if field 3 meets
criteria value = HOL stop, if not value should be null.
Example My table [Employees] has three fields
field 1 offday1 field 2 offday2 field designated Holiday
On a report in calendar format I need make work schedule
Sat Sun Mon Tue Wed Thur Fri
under each item I need text box based on the Value of
fields 1, 2, or 3 in Employees table. If field one is
value Sun I would need O/D2 in text box under Sunday
I am going nuts!
criterias, If field one equals criteria value would be O/D1
stop, if not go to field two, if meets criteria value would
= O/D2 stop, if not go to field 3, if field 3 meets
criteria value = HOL stop, if not value should be null.
Example My table [Employees] has three fields
field 1 offday1 field 2 offday2 field designated Holiday
On a report in calendar format I need make work schedule
Sat Sun Mon Tue Wed Thur Fri
under each item I need text box based on the Value of
fields 1, 2, or 3 in Employees table. If field one is
value Sun I would need O/D2 in text box under Sunday
I am going nuts!