Year-over-year sales growth

I'm trying to add a field in a report that shows year over year sales growth.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13652-year-over-year-sales-growth.html

Imagine a table with the following fields:
Year - Sales
2005 $100,000
2004 $50,000

In a report I want to show the growth but don't know how I would build the
expression.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

I built two queries to pull the data. I based the table on the data you
presented.

Ron_Sales_Past --
SELECT Ron_Sales.Year, [Year]-1 AS [Past Year], Ron_Sales.Sales
FROM Ron_Sales;

SELECT [Ron_Sales].[Year]+1 AS [Sales Year], Ron_Sales_Past.Sales AS
[Current Year], Ron_Sales.Sales AS [Year Ago Sales],
[Ron_Sales_Past].[Sales]-[Ron_Sales].[Sales] AS [Growth over last year]
FROM Ron_Sales INNER JOIN Ron_Sales_Past ON Ron_Sales.Year =
Ron_Sales_Past.[Past Year]
ORDER BY [Ron_Sales].[Year]+1;

"ron" wrote:

> I'm trying to add a field in a report that shows year over year sales growth.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13652
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13652
>
> Imagine a table with the following fields:
> Year - Sales
> 2005 $100,000
> 2004 $50,000
>
> In a report I want to show the growth but don't know how I would build the
> expression.