G
Guest
I have 9 fast food locations in my sales table. There is a field for net
sales, month and one for year. I would like to compare January 2006 (etc)
sales to January 2007 sales in a report. Is there a way to build a query that
would compare month by month? The formula is a simple (TY-LY)/LY. All I want
to see on the report from last year is a percentage up or down and the
current months sales. I am a new user excited about reports and forms but
cannot start building those until I get this problem solved. Maybe I need 2
tables, one for 2006 and one for 2007. Help!
sales, month and one for year. I would like to compare January 2006 (etc)
sales to January 2007 sales in a report. Is there a way to build a query that
would compare month by month? The formula is a simple (TY-LY)/LY. All I want
to see on the report from last year is a percentage up or down and the
current months sales. I am a new user excited about reports and forms but
cannot start building those until I get this problem solved. Maybe I need 2
tables, one for 2006 and one for 2007. Help!