RE: Compare 1st qtr this year to 4th qtr last year
- From: KARL DEWEY <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Feb 2008 10:37:03 -0800
What table is ProductionDate in?
--
KARL DEWEY
Build a little - Test a little
"diaare" wrote:
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
- Follow-Ups:
- RE: Compare 1st qtr this year to 4th qtr last year
- From: diaare
- RE: Compare 1st qtr this year to 4th qtr last year
- References:
- Compare 1st qtr this year to 4th qtr last year
- From: diaare
- RE: Compare 1st qtr this year to 4th qtr last year
- From: diaare
- Compare 1st qtr this year to 4th qtr last year
- Prev by Date: Re: How do I get rid of blank pages in a report?
- Next by Date: RE: Compare 1st qtr this year to 4th qtr last year
- Previous by thread: RE: Compare 1st qtr this year to 4th qtr last year
- Next by thread: RE: Compare 1st qtr this year to 4th qtr last year
- Index(es):
Relevant Pages
|
