Solved

ASP.NET Form / SQL Logic

Posted on 2011-09-09
3
176 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
  • 2
3 Comments
 
LVL 83

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now