Menu DEVPPL Search
157.094
MEMBERS
15.930
TOPICS
63.132
POSTS
  562
FLASH GAMES
7.723
TUTORIALS
 

Login

E-mail:
Password:

VB.Net and Access Column fields calculations

0

Loading

VB.Net and Access Column fields calculations

Postby Jadallah » Wed Aug 31, 2011 8:48 am

Hello guys,

I am doing this application for my own business. Each time a car in my company fills gas i enter data in table with columns [filldate|brand|model|plateno|mileage|gas] where mileage in the mileage (k/m) when car is filled and gas is the amount of liters that a car fills.
What i want to do is get a report in datagridview with columns [brand|model|plateno|mileagedriven|totalGas|AVG] where (mileagedriven = MAX[mileage] - MIN[mileage] of a certain car) and totalGas = SUM(gas) by a certain car and AVG = totalGas/mileagedriven. (for sure it is grouped by plateno)
The point of this is to know what is the average consumption. I've been working on this application for one month but like from 10 days ago i got stuck with this issue and don't seem to get even close of solving it and i'm not a computer student. Programming is a hobby.


Any help is really appreciated...
Thanks
Jadallah
 
Reputation: 0
Posts: 1
Joined: Wed Aug 31, 2011 8:06 am
Highscores: 0
Arcade winning challenges: 0

VB.Net and Access Column fields calculations - Sponsored results

Sponsored results

Login to get rid of ads

 

^ Back to Top