Comparing values from different time periods

  • Thread starter Thread starter Michelle Dawson
  • Start date Start date
M

Michelle Dawson

I have created a query and report that calculates petrol
usage 'litres/100km' by adding fuel purchases over a
defined time period using Fist and Last to calculate
difference in milage.

I want to calculate 'litres/100km' from a second defined
time period to compare against the first result (eg
similar to comparing sales from two different time
periods). I have tried to use First and Last date for the
second time period too and relabeling fields to
differentiate them from the field names in the second
query.

I have not found a way to bring all the information
together in one report with the second 'litres/100km'
working. I have tried joining the information in a query
but it does not seem to work, nor does trying to bring the
information together in a report

Any ideas would be appreciated.


Michelle
 
Michelle.
I would approach this by creating two queries, each with
its own start and end date, with the sum of the fuels used
during that period, and with the max and min of the milage
(KM)
than in your report you can combine these two single
record queries for the necessary information
Query1 "RefData"
RefStartDate, RefEndDate, RefFuelSum, RefMinKM, RefMaxKM
Query2 "CurrentData"
CurStartDate, CurEndDate, CurFuelSum, CurMinKM, CurMaxKM
Now in the report you can compare any of these data items.
Hope this helps.
Fons
 
Back
Top