ASP.NET Form / SQL Logic


Hi,
I'm not sure if this is the correct forum for this question. I'm not necessarily looking for code, but just help with the logic on how I can get something to work .......

I'm creating an ASP.NET (vb) application that is going to be a car mileage claim form. The user inputs car journeys indicating their start mileage and end mileage, the form is totalled and once a month submitted to the payroll section to pay so much per mile.

When the user enters a new journey, the start mileage of the new journey must be equal to or greater than the end mileage of the last journey they input.  This in theory works fine – UNTIL, the user forgets to put one day’s journey in, and then the new journeys start and end mileage are in-between another journey.

LVL 1
nchtAsked:
Who is Participating?
 
nchtAuthor Commented:
Thanks
0
 
Dave BaldwinFixer of ProblemsCommented:
I think that you should have three variables to check.  Starting Date/Time, starting mileage, and ending mileage.  Possibly Ending Date/Time too if you want to be real picky.  If you have the Starting Date/Time and use that to order the results then you wont' have the overlapping results problem (at least not for legitimate data).  Actually if you just sort on the starting mileage, the results should end up in the correct order.
0
 
nchtAuthor Commented:
Found solution elswhere.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.