?
Solved

ASP.NET Form / SQL Logic

Posted on 2011-09-09
3
Medium Priority
?
182 Views
Last Modified: 2012-05-12

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.

0
Comment
Question by:ncht
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 36512996
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
 
LVL 1

Accepted Solution

by:
ncht earned 0 total points
ID: 37216031
Thanks
0
 
LVL 1

Author Closing Comment

by:ncht
ID: 37236421
Found solution elswhere.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month9 days, 17 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question