Help designating a description to a value...

[kalebson]

I have a scheduling unit that associates a number to a particular name.

In this example Break=66 and Lunch=76.

What I would like to do is setup something that will tell me "which break". Like "Break 1" and "Break 2"

Here is what I have to work with:

Emp# ID# Code StartMin Desc
6666 5555 66 870 Break
6666 5555 76 1005 Lunch
6666 5555 66 1150 Break


I tried this thinking it might designate it based on the StartMin:

Desc: IIf(

=66 And First([StMin]),"Break 1",IIf([Code]=66 And Last([StMin]),"Break 2","Lunch"))

However this still just shows each as "Break 1". Any ideas would be great. Thanks.

 

[gemma-the-husky]

if it is important to distinguish between a mid-am break and a mid-pm break, you ought to give them different reference numbers.

i'm not sure wehat your startmin means, but could you use that if necessary to make the distinction. You can't use operators like first or last, but wouldn't the absolute time help/ ie "firstbreak" must be before 12 noon ,and "secondbreak" after noon.