Re: can I reduce the number of queries?

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

"jonm4102" <sutasa@xxxxxxxxx> wrote in message
news:1153163405.325682.153580@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • can I reduce the number of queries?
    ... stores. ... 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, ...
    (comp.databases.ms-access)
  • Re: migrating data process with data type mismatch
    ... One approach might be to create queries against the old data that parses it ... John Smith#1's other data to the correct John Smith in the new data. ... I'm pretty green when it comes to migrating data and action queries and ... the old db stores a text entry and doesn't ...
    (microsoft.public.access.externaldata)
  • Re: Exporting mail and backing up- Help!
    ... making numerous errors landing up with different stores I am beginning to ... understand what I am now doing but I still have some queries. ... When trying to delete these extra stores I eventually found that all my ... When I compact folders every month are they added to the existing folders ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Cross tab query construction with Subqueries
    ... Perhaps the single Crosstab Query is more efficient than several nested Select Queries, but to determine how much so you'd probably need to run your own tests. ... So I attached it to [Bookings], since it made no sense to me to have 3 [Revenue] records on a line in the datasheet and only one of the attached fields. ...
    (microsoft.public.access.queries)
  • RE: Set Up Query To Look Like A Pivot Table
    ... I was trying to avoid having to create 12 different queries. ... I have to report the revenue for 9 different ... I'd have to create one query per Area per Month. ...
    (microsoft.public.access.queries)