By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

can I reduce the number of queries?

P: n/a
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

Jul 17 '06 #1
Share this Question
Share on Google+
1 Reply


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

"jonm4102" <su****@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
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

Jul 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.