Advertisement

05.28.2008 at 11:12AM PDT, ID: 23439037
[x]
Attachment Details

Problem with scale in stacked bar chart

Asked by fh_freese in Microsoft Access Database

Tags: Microsoft, Access, 2003

I use the below code for my stacked bar chart. When I execute the qry I get what I expect. When I look at the bar chart data I see what I expect. Here's what I get on my Y axis scale:
0
1
1
2
2
3
3
4
Not
0
1
2
3
4
5
I can not find the problem.Start Free Trial
1:
2:
3:
4:
SELECT tblDailyProduction.ProductionDate,( ([B26CarrierPerUnit])/60) AS [Carrier], (([B26CasePerUnit])/60) AS [Case],( ([B26DiffAssemblyPerUnit])/60) AS [Diff Assembly],(([B26InspectionPerUnit])/60) AS[Inspection], (([B26ShaftPerUnit])/60) AS [Shaft],( ([B26HousingPerUnit])/60) AS [Housing], (([B26AssemblyPerUnit])/60) AS [Assembly], (([B26LogisiticsPerUnit])/60) AS [Logistics]
FROM qryB26RearAxleLogisticsPerUnit INNER JOIN (qryB26RearAxleShaftPerUnit INNER JOIN (qryB26RearAxleHousingPerUnit INNER JOIN (qryB26RearAxleAssemblyInspectionPerUnit INNER JOIN (qryB26RearAxleDiffAssemblyPerUnit INNER JOIN (qryB26RearAxleCasePerUnit INNER JOIN (qryB26RearAxleCarrierPerUnit INNER JOIN (qryB26RearAxleAssemblyPerUnit INNER JOIN tblDailyProduction ON qryB26RearAxleAssemblyPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleCarrierPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleCasePerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleDiffAssemblyPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleAssemblyInspectionPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleHousingPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleShaftPerUnit.ProductionDate = tblDailyProduction.ProductionDate) ON qryB26RearAxleLogisticsPerUnit.ProductionDate = tblDailyProduction.ProductionDate
GROUP BY tblDailyProduction.ProductionDate,( ([B26CarrierPerUnit])/60), (([B26CasePerUnit])/60),(([B26DiffAssemblyPerUnit])/60), (([B26InspectionPerUnit])/60),( ([B26ShaftPerUnit])/60), (([B26HousingPerUnit])/60), (([B26AssemblyPerUnit])/60), (([B26LogisiticsPerUnit])/60) HAVING (((tblDailyProduction.ProductionDate) BETWEEN [Forms]![frmDailyReport]![txtStartDate] AND [Forms]![frmDailyReport]![txtEndDate]))
;
 
Loading Advertisement...
 
[+][-]05.28.2008 at 11:26AM PDT, ID: 21662934

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 11:38AM PDT, ID: 21663039

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 01:22PM PDT, ID: 21664027

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: Microsoft, Access, 2003
Sign Up Now!
Solution Provided By: fh_freese
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628