i have created a bar chart showing total pounds by city but for some reason only one of the 12 names is not showing up. Fairfiled has fewer characters than Youngstown so it can not be a length issue. Any thoughts? I would appreciate any help. Erin
Is the y-axis value a field or a calculation (SELECT statement)? If it's a SELECT statement, do you see the field in the Data Viewer (assuming you have "Advanced" FMP)?
Maybe you could post your data x and y, so we can try to duplicate/fix your issue?
The pounds reported are a sum grouped by foodbank name. One sum from another report. The city is on a different table connected to the foodbank name. sorry not much of a techie to know how you need it but does this help?
It is weird that only one city name did not show up but the pounds did. tried logging out and back in and still nothing. What may have affected it that Fairfield was the last name entered on the list.
Is the blank city the result of a name missing or is it results that have a blank city?
If not, do you have a list of your cities for comparison?
this is all that is in that table. The foodbank name is the primary key
Never mind. After your help ans stepping away from it for a minute i found the error. Thank you for you help. It is greatly appreciated. sometimes it helps to step away and take a breath. Have a great weekend.
Yep, it's always good to go for a walk or something where you don't have immediate access to the computer when you're stuck on something. I often get my best ideas when I'm nowhere near the box with the blinking lights...
Retrieving data ...