J
Jay
I have a summary query where the records are grouped on the following
fields:
-SaleMonth
-Car
-MileageBand
-RegPlate
And the only other field, 'Price', is averaged.
The 'RegPlate' field can be one of two vales: 2002 52 or 2003 52
So what I'm trying to achieve is have a query which calculates the
difference between the 2002 52 average price and the 2003 52 average price
(for all records where the SaleMonth, Car & Mileage Band are the same)
For example let's say I have the following two records in my query as it
stands at the moment:
SaleMonth Car MileageBand RegPlate AvgPrice
-----------------------------------------------------------
January Ford Focus MileageBandA 2002 52 £5000
January Ford Focus MileageBandA 2003 52 £5500
I want my new query to calculate the % difference between the 2002 52 value
(£5000) and the 2003 52 vale (£5500), which is 10%.
If anyone could help I'd be extremely grateful.
Many thanks
Jason
fields:
-SaleMonth
-Car
-MileageBand
-RegPlate
And the only other field, 'Price', is averaged.
The 'RegPlate' field can be one of two vales: 2002 52 or 2003 52
So what I'm trying to achieve is have a query which calculates the
difference between the 2002 52 average price and the 2003 52 average price
(for all records where the SaleMonth, Car & Mileage Band are the same)
For example let's say I have the following two records in my query as it
stands at the moment:
SaleMonth Car MileageBand RegPlate AvgPrice
-----------------------------------------------------------
January Ford Focus MileageBandA 2002 52 £5000
January Ford Focus MileageBandA 2003 52 £5500
I want my new query to calculate the % difference between the 2002 52 value
(£5000) and the 2003 52 vale (£5500), which is 10%.
If anyone could help I'd be extremely grateful.
Many thanks
Jason