gigifarrow
asked on
Making Charts
I have a report that I need to add a chart. However when I make the chart the data in the fields do not match the reports data. I know I can input the correct data, but that will take forever. How do I make the data from the report match the data from the chart? I need the chart to show the locations as the headers and the data would be the precentage of "Defective Items" for each location. Below is my database. It includes the report that I am working on.
Inventory3-db.accdb
Inventory3-db.accdb
Two hours is not that long to wait....
Remember, we are all volunteers here...
;-)
Remember, we are all volunteers here...
;-)
ASKER
I understand what you are saying. However, I am paying for this every month.
Again, a lot of detail is missing here...
In order to get a "Perentage" you need two things
1. The Total Items
2. ...and the Total Defective Items
So if you had 123 items and 51 were defective, the formula for the percent would be:
51/123=.415
...or 41.5%.
In your report you only the defective Items (by Location) are listed.
Where can I find the "Total" items by location
JeffCoachman
In order to get a "Perentage" you need two things
1. The Total Items
2. ...and the Total Defective Items
So if you had 123 items and 51 were defective, the formula for the percent would be:
51/123=.415
...or 41.5%.
In your report you only the defective Items (by Location) are listed.
Where can I find the "Total" items by location
JeffCoachman
ASKER
I hope this is what you are asking. If you look at the report after it names each defect there is a total. Then there is a grand total of all the defective Items. I hope those are the totals you are asking about.
This is why I always as for:
A Clear, Graphical example of the exact output you are requesting...
In other words what *exactly* do you want displayed"
(The actual Values)
Put another way, show me the *exact* percent values you want for each record/group.
In other words, do you want the Korea percents to be the percentage of the Korea Total , or the grand Total...?
Put another way, this is all I need:
Show me what you have (you have done this)
Show me what you want (don't describe what you want, *Show* me *exactly and graphically* what you want.)
JeffCoachman
A Clear, Graphical example of the exact output you are requesting...
In other words what *exactly* do you want displayed"
(The actual Values)
Put another way, show me the *exact* percent values you want for each record/group.
In other words, do you want the Korea percents to be the percentage of the Korea Total , or the grand Total...?
Put another way, this is all I need:
Show me what you have (you have done this)
Show me what you want (don't describe what you want, *Show* me *exactly and graphically* what you want.)
JeffCoachman
ASKER
This is an example the precentage is not right so i need the precentage of each by location. These equation needs to be in a chart. I can make a chart but it just gives me a generic chart.
Location defect total
Korea Leakage 5
Loss 2
grand total 7 = 20%
Colorado Leakage 3
Loss 1
grand total 4 = 4%
Location defect total
Korea Leakage 5
Loss 2
grand total 7 = 20%
Colorado Leakage 3
Loss 1
grand total 4 = 4%
Then give this a try, it has both Group Percents, and Percents of the Grand total
JeffCoachman
Inventory3-db.accdb
JeffCoachman
Inventory3-db.accdb
LOL!
Oh!, In all the posts, I forgot you wanted a *chart*...
Gimme a minute...
;-)
Jeff
Oh!, In all the posts, I forgot you wanted a *chart*...
Gimme a minute...
;-)
Jeff
ASKER
TotalByLocation: DSum("Quantity","inventory _tbl","Loc ation=" & "'" & [Location] & "'") could you please explain what the "&" does?
For lack of a simpler explanation...
"&" in VBA is the symbol for "concatenation"
For Example:
1+1=2
1&1=11
"Jeffrey" & " " & "Coachman" = Jeffrey Coachman
"&" in VBA is the symbol for "concatenation"
For Example:
1+1=2
1&1=11
"Jeffrey" & " " & "Coachman" = Jeffrey Coachman
Just a (rather forceful) note here.
;-)
Please *Do Not* use Lookup field in your tables (ex Location in the inventory table)
For all the reasons listed here:
http://access.mvps.org/access/lookupfields.htm
But it this case specifically, it wreaks havoc when trying to create your Chart, because the chart will only see the "Value", not the lookup
...stay tuned
;-)
Please *Do Not* use Lookup field in your tables (ex Location in the inventory table)
For all the reasons listed here:
http://access.mvps.org/access/lookupfields.htm
But it this case specifically, it wreaks havoc when trying to create your Chart, because the chart will only see the "Value", not the lookup
...stay tuned
ASKER
ok I wont use lookup tables. Thanks for the advice and help.
Also don't name all your Primary Keys "ID", this causes confusion when referring to the "ID" field, because every table has this exact same Primary key name.
In the Inventory Table, the Primary Key should be: InventoryID
In the Location Table, the Primary Key should be: LocationID
In the Customer Table, the Primary Key should be: CustomerID
In the SlabMask Table, the Primary Key should be: SlabMaskID
In the QaeVd23AP45 Table, the Primary Key should be:QaeVd23AP45ID
;-)
..Still working on the chart...
In the Inventory Table, the Primary Key should be: InventoryID
In the Location Table, the Primary Key should be: LocationID
In the Customer Table, the Primary Key should be: CustomerID
In the SlabMask Table, the Primary Key should be: SlabMaskID
In the QaeVd23AP45 Table, the Primary Key should be:QaeVd23AP45ID
;-)
..Still working on the chart...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note that in order for chats to display correctly, you must open the report in "Print Preview" explicitly.
Note that in order for chats to display correctly, you must open the report in "Print Preview" explicitly.
should be:
Note that in order for charts to display correctly, you must open the report in "Print Preview" explicitly.
should be:
Note that in order for charts to display correctly, you must open the report in "Print Preview" explicitly.
ASKER