Solved

ASP.NET Form / SQL Logic

Posted on 2011-09-09
3
177 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS ReportViewer report timeout 7 122
Replace &lt; with < 14 59
Web site error 3 40
C# LINQ ForEach() question 6 22
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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