I have a table that stores vehicle number, product, odometer, quantity and trantime as well as several other fields. All odometer readings are stored in the same field. I need to find the average miles per gallon over a 4 year period. Below is my query:
SELECT MainTrans.SITEID...