I am trying to write an analysis piece in my program, and I think that is to kill a wall. , I am trying to use the compiled data in useful statistics from the everyday use of the program - such as the cost of items, alternating time and total expenditure, for my first part - here written in Access 2003 The query that contains a SQL Server on the network On reaching a table:
SELECT dbo_tblPODetail.intPurchaseOrderInstance, dbo_tblPODetail.strSupplierCode, dbo_tblPOGaugeDetail strGageDetailID, dbo_Gage_Master.Description, dbo_Gage_Master.Current_Location, dbo_tblPOGaugeDetail.datGageReceived, dbo_tblPOGaugeDetail.intTurnaroundDaysOut, the dbo_tblPOGaugeDetail.intGageCost ( dbo_Supplier_Master insider who ((dbo_tblPOGaugeDetail insider on dbo_tblPOGaugeDetail.intGagePOID = dbo_tblPODetail.intPurchaseOrderInstance dbo_tblPODetail Join) insider who dbo_Supplier_Master.Supplier_Code = on dbo_tblPOGaugeDetail.strGageDetailID = dbo_Gage_Master .Gage_ID) on dbo_Gage_Master dbo_Gage_Master.Supplier_Code) dbo_tblPODetail.strSupplierCode = dbo_tblSupplierInfo interiors. Where strSupplierID (((dbo_tblPOGaugeDetail.datGageReceived) Not null) and dbo_tblPOGaugeDetail.datGageReceived ordered by ((dbo_tblPOGaugeDetail.bolGageBER) = false) and dbo_tblSupplierInfo join ((dbo_tblPO Gejditetkbogejklibet) = true)); This will give me a list of all items returned by their associated calibrator, not beyond the cost repair, on which date they returned, and how much was spent. I want to take this data, and show it on the bar chart object on the supplier's form. I tried a Transform Pivot Roussource, but I could not get the data together for any group in a meaningful way. Either two things happened:
1> The data was collected to collect the total cost per year for the calibrator. Useful, but I'm not for this object.
2 & gt; Data is presented with no group, all costs of a single individual are calculated, and Y axis is calculated. This format is useless, but the Y axis is correct.
I am looking for the number of objects for the Y-axis, but I need to know how five graph bars whose groups are either fixed (0 to 249 9, 250 to 49.99, 500 to 74.99, 750 to 999.99, 1000+) or dynamically calculated based on data (most likely using a standard deviation or any other statistical function I can not do it
Any help with this is greatly appreciated, it is free It is a question because it is a question which is asked by the powers of all the times (together 'how much do we spend with them?' And 'how long does it take to get the goods back?'). Let me know.
I separate the crosstab from the graph (UI) / P>
Have you tried using the CrossStab Wizard?
Comments
Post a Comment