|
|
|
Vacatures vandaag in Nederland
|
Design engineer (Feb 01 2008 02:59 GMT) - Busch, wereldleider op industrieel vacuümgebied Busch beschikt in ruim 30 landen over zelfstandige vestigingen die zich al meer dan 40 jaar bezighoud... |
Microsoft Office Software
|
need help selecting betwween dates (Feb 01 2008 02:59 GMT) - Good day this works fine except but for a vehicle change March 16 SELECT MIN([start mileage]) AS [Start of year mileage], MAX([home mileage]) AS [End of year mileage], MAX([home mileage])-MIN([start mileage]) AS [Total mileage], SUM([home mileage]-[start mileage]) AS [Total business mileage], SUM([gas]) AS [Sum Of gas], SUM([US gas]) AS [Sum Of US gas], SUM([US gas2]) AS [Sum Of US gas2], SUM([servise $]) AS [Sum Of servise $], SUM([us cost]) AS [Sum Of us cost], SUM([gas pur]) AS [Sum Of gas pur], SUM([insureance]) AS [Sum Of insureance], SUM([plate]) AS [Sum Of plate] FROM [travel 2007]; what I need is total mileage which is as posted but Jan1 to March16 to be added to March16 to end of year due to vehicle change I have a negative mileage can any help with where to place between dates for total mileage value Thank You Stephen |
Sly Bald Guys Forum
|
"Excuse me, you're head is bleeding...." (Feb 01 2008 02:59 GMT) - Okay, so my first few months shaving, I hoped out of the shower, shaved quickly, and off to catch the bus to campus. We were riding along for about 15 minutes, and the bus driver pulls over, full bus mind you, and stops the bus. |
|