I was wondering if anyone could hel

[scrano]

I was wondering if anyone could help me. I have a form that contains details for organisations it accepts fees and expenses for these organisations and it then apply these fees and expenses based on a date range that the user inputs, in this case these fields are named FIRST DATE and LAST DATE, so it might run expenses of 12% and fees of 2% between 1/1/01 and 1/5/01 and then expenses of 10% and fees of 3% between 2/5/01 and 25/12/01, which works up until a user overlaps the last date on the previous record with the first date on the next record, so instead of the first record reading between 1/1/01 and 1/5/01 and the next record 2/5/01 and 25/12/01, someone might put in on the first record between 1/1/01 and 1/5/01 and the next record between 1/2/01 and 11/11/01. What I want to do is eliminate the possibility of human error and have something check to see if the value of LAST DATE field on the record previous exceeds the value of FIRST DATE on the current record and if so adjust the value accordingly. Any help would greatly appreciated. Thanks in advance

 

[lameid]

After Update event and Dmax() function