View Single Post
  #1  
Old January 31st, 2010, 11:28 PM posted to microsoft.public.access.tablesdbdesign
rheaume7
external usenet poster
 
Posts: 1
Default Subtacting AvgSales by Year

I am totally self taught in Access. I currently use Access 2000. I don't know
code, so if we could keep this basic, I would appreciate it. I created a
report that shows my customer sales for the year. I have them on the report
as the following:

Customer JOES AUTO REPAIR

YEAR SALES AVGSALES
2008 12000.00 1000.00
2009 24000.00 2000.00

What I want to do is add/subtract the avg sales by year to see who has
improved/weakened.

Any help would be greatly appreciated.