RE: Compare 1st qtr this year to 4th qtr last year

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Gladly.

PARAMETERS [Which Year?] Value;
TRANSFORM Sum(Production_all.QtyProduced) AS SumOfQtyProduced
SELECT Models.Horizontal, Models.Freezer, Models.NumberofDoors,
CoolerTypes.ProductionGroup, CoolerTypes.StyleID, Models.CoolerTypeID,
Production_all.ModelID, Styles.StyleType, Sum(Production_all.QtyProduced) AS
[Total Of QtyProduced]
FROM Styles RIGHT JOIN (CoolerTypes RIGHT JOIN (Models RIGHT JOIN
Production_all ON Models.ModelID = Production_all.ModelID) ON
CoolerTypes.CoolerTypeID = Models.CoolerTypeID) ON Styles.StyleID =
CoolerTypes.StyleID
WHERE (((Models.CoolerTypeID)<>9999) AND ((Production_all.TheYear)=[which
year?]))
GROUP BY Models.Horizontal, Models.Freezer, Models.NumberofDoors,
CoolerTypes.ProductionGroup, CoolerTypes.StyleID, Models.CoolerTypeID,
Production_all.ModelID, Styles.StyleType, Production_all.TheYear
PIVOT "Qtr " & Format([ProductionDate],"q");


Thanks, for your offer to help. Please have patience with me as I am fairly
new at this and nearly all self taught (probably incorrectly).

Diane

"KARL DEWEY" wrote:

Post your query SQL.
--
KARL DEWEY
Build a little - Test a little


"diaare" wrote:

I have created a report that compares production data from one qtr to the
previous qtr.

It is based on a crosstab query that sums the production numbers by qtr. I
have a parameter that prompts the user to choose which years production data
to use (filters by year).

This works wonderful when comparing 2nd to 1st, 3rd to 2nd, and 4th to 3rd.
However, obviously, it doesn't work to compare 4th to 1st, because now I have
data from two different production years.

I now realize I need to restructure the query so that I can compare
quarterly data from two years, but I don't know how.

Could someone please guide me in the right direction?

Thanks,
Diane
.

Relevant Pages

  • Compare 1st qtr this year to 4th qtr last year
    ... I have created a report that compares production data from one qtr to the ... It is based on a crosstab query that sums the production numbers by qtr. ... However, obviously, it doesn't work to compare 4th to 1st, because now I have ...
    (microsoft.public.access.reports)
  • Re: Learnig instruments?
    ... - as far as I know the Czech models are still in production: the business was bought by a family company and they took on some of the Delicia production staff. ... Is best on the Walther and paolo Soprany model with Italian reeds. ... Would need to compare more models. ... It is quite common for teachers in Germany to expect Hohner instruments, but that demand is slowly dying. ...
    (rec.music.makers.squeezebox)
  • Re: McCoy - any fans of him left out there?
    ... Genesis with Dead Planet). ... post production dubbing and editing were ... in terms of these shows the Hartnell stories are quite sophisticated ... These stories compare well with contemporary American productions like ...
    (rec.arts.drwho)
  • Re: Mainframer needs help on Power Cobol
    ... I've been busy putting out a production fire (luckily it ain't my fault, ... I can switch from the M/F IDE to my ... I also had a compare system built into it. ...
    (comp.lang.cobol)
  • Re: Pathway Server Classes
    ... production and disaster recoveryserverclasses." ... until the shareware is put up next month. ... where you can not only compare the current prod/dr pathways, ...
    (comp.sys.tandem)