B
Bunky
Here is the scenario. Mgmt wants me to determine if an agent has perfect
attendance for the past week. If they do, their name is entered in for a
drawing for $$. This keeps going for 1 quarter so the agents can have 12
entries or none. I have got it set up that I append the last weeks data to a
quarterly table after the processing for the week has occurred. Now, let's
say it is now time to pull the winner. I have a random number routine that
firsts does a count of the entries in the quarterly table and then returns a
totally random number. I want to then match that random number with the
quarterly table and pick out the winner based on the number returned. What I
think I need is a way to have my own sequence number starting at 1 and going
for the entire quarterly table after the table is created. I tried
DMax("[MySeqNum]","PerfectWk")+1 in the default area but it did not update.
Ideas???
attendance for the past week. If they do, their name is entered in for a
drawing for $$. This keeps going for 1 quarter so the agents can have 12
entries or none. I have got it set up that I append the last weeks data to a
quarterly table after the processing for the week has occurred. Now, let's
say it is now time to pull the winner. I have a random number routine that
firsts does a count of the entries in the quarterly table and then returns a
totally random number. I want to then match that random number with the
quarterly table and pick out the winner based on the number returned. What I
think I need is a way to have my own sequence number starting at 1 and going
for the entire quarterly table after the table is created. I tried
DMax("[MySeqNum]","PerfectWk")+1 in the default area but it did not update.
Ideas???