Search results

  1. T

    MPG query

    Thank You very much, that worked!
  2. T

    MPG query

    The sample I posted previously was not a good sampling so I have posted a better data sample. The field names are first in the same order as the data. The query should create 2 fields "PREVODOMETER" AND "MPG" VEHICLEID,ODOMETER,PRODUCT,TRANTIME,QUANTITY,AGENCY...
  3. T

    MPG query

    The query should produce the avg mpg for the fleet for a specific period of time.
  4. T

    MPG query

    Oops, I did not give the correct field names. The table name is MainTrans; field names are VEHICLEID, ODOMETER, PRODUCT, TRANTIME, QUANTITY, AGENCY. Sorry....
  5. T

    MPG query

    Vehicle# Odometer Product TranDate Qty Dept 00010-08 63595 2 05-Oct-12 32.78 4108A 00030-08 64998 2 05-Oct-12 25.7 4108A 00030-08 65082 2 08-Oct-12 13.1 4108A 00024-08 67647 2 08-Oct-12 29.6 4108A 00023-08 73904 2 05-Oct-12 41.6 4108A 00020-08 81908 2 05-Oct-12 32 4108A 00022-08 86066 2...
  6. T

    MPG query

    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...
Back
Top Bottom