Hi Ron,
You could create a variable to hold the number of hours/minutes for the current
row and then to create an entry or exit proceedure to sum the time for the rows
for the Id# and date and then add the variable to it. If it exceeds 8 then ask the
question with a dialog box and skip to another field or skip 0 or whatever you
want to do.
Best regards,
Mike Young
On Sat, 28 Apr 2001 07:18:48 -0600, Ron Gries wrote:
>Is there a way to display a message. ie. 'Your hours exceed 8 for the day'
>Is this correct?', when entering records into a table. Since there may be
>more than one entry per day for each individual, I want the program to
>compare individuals with the same id# and entry date. If the hours total >8
>then display message and allow entry.
>
