Recent content by dannylam4

Hello hello, I was wondering if someone could help me with this piechart issue. So I have a query that basically holds: Query2 Food Query Store Food Amount #1 Apple 20 #1 Oranges 10 #1 Peaches 30 #2 Apple 10 #2 Oranges 10 #3 Apple 4 #3 Oranges 5 #3...

Ahh, ",0" I forgot that part... I guess that makes sense. thanks, haha.

Cool ^^ It got all 3 categories to appear, though Strength's count is still blank. I wonder if that'll cause problems when attempting to build a graph off it... --Nope! Works perfectly fine! Thank you veeeery much, haha!

Hm... so if I'm understanding this correctly, have my query in the first post (with join and all) and then create a second query that has the nz() function? If so, I don't think I did it right, haha. Here's the code for the 2nd query: SELECT nz([Pre Parent].CountOfIN_Category) AS Counter FROM...

in here: nz(Count(Rating.IN_Category)) AS CountOfIN_Category ? That didn't seem to work either... so I guess it's not looking it as null? It just doesn't want to display 0's?

So I have a table that does a count on ratings in a certain category. The problem is that I want a number to appear for each of the three categories, even when the count returns nothing. In other words, we have 3 rating types, "poor, good, and great," and I need a result for it, even if no one...

I was thinking of that, forcing the value to be .1 if it was actually 0, but I don't know how to do the VB code to force it like that.

Hello :D I have an issue with Access I was hoping someone could help me on. So I have this pie chart graph with 3 sections, colored red for East, Green for West, and Blue for North. Now the problem is that sometimes, the data that I pull in doesn't have a "West" and therefor doesn't add it to...