can I reduce the number of queries?

Thanks for your previous post. I've run into another hurdle, and would
greatly appreciate any help you may be able to offer. I have revenue
data sorted by month and years for a number of distinctly labeled
stores (imagine a Center ID). I would like to find the percentage of
"gainers" (stores whose monthly revenues exceed the previous month's
revenues) out of the all the stores. I know how to determine this by
using an individual queries to sort out each store's revenue by year
and month, and then use another query to classify gainers v. decliners,

and then (Fnally!) calculate the percentages. Is there an easier way to

do this than to run around 50 queries (one for each month for 4 years)?

Thanks.

Jonathan

Summation query grouped on Store, Month/Year in the 1st 2 queries, should
reduce the count to 3.

"jonm4102" <sutasa@gmail.comwrote in message
news:1153163405.325682.153580@i42g2000cwa.googlegr oups.com...