Prev: Searching for specific word in query
Next: concatenating two vendor codes
From: Lanz on 20 Jan 2010 12:55
I have data from a query in one chart showing revenue totals from July2009 to
December 2009. Then I have another chart showing revenue totals from July2009
to January 2010. I want to create a chart that shows revenue for only the
month of January2010. This means I need to subtract the December2009 revenue
from the January2010 revenue. Is there a query for this?
From: Lynn Trapp on 20 Jan 2010 14:15
Can you please post the structure of your tables?

--
Lynn Trapp
MCP, MOS, MCAS


"Lanz" wrote:

> I have data from a query in one chart showing revenue totals from July2009 to
> December 2009. Then I have another chart showing revenue totals from July2009
> to January 2010. I want to create a chart that shows revenue for only the
> month of January2010. This means I need to subtract the December2009 revenue
> from the January2010 revenue. Is there a query for this?
 | 
Pages: 1
Prev: Searching for specific word in query
Next: concatenating two vendor codes