Getting Rid of <> Series in Column and Bar Charts

[Buckar00B0nzai]

I have a database (of course) that tracks services requests by technicians that complete them. I want to create a stacked bar chart that displays all of the technicians and the number of completed service requests - even if the technician has not completed any.

To accomplish this, I designed a query based on the main table that pulls: [Technician], [Service_Requested], [Status] = "Complete", and Count[Service_Requested]. Next, I designed a second query based on the first query that includes a table with each technician's name listed as a unique value. I linked the [Technician] field between the table and the query, and set the properties to pull all of the values from the table, and only those values from the query where the joined fields are equal. The result is great - all technicians are listed, only completed services and their counts are detailed, and there are null values (empty fields) for the technicians who have yet to complete work. However...

When I chart this baby I get a "<>" value in the legend. How do I fix this?

Thanks for your help in advance.

BB

 

[dhookom]

Can you post the Row Source property of your Chart? I think you might need to use Nz() in some manner.

Duane
Hook'D on Access
MS Access MVP

 

[Buckar00B0nzai]

TRANSFORM Sum([CountOfSERVICE REQUESTED]) AS [SumOfCountOfSERVICE REQUESTED] SELECT [Technicians] FROM [Services Complete by Technician Part 2 Query] GROUP BY [Technicians] PIVOT [SERVICE REQUESTED];

Does this help?

 

[SkipVought]

You might also post some representative data from your table.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Buckar00B0nzai]

How would you like to see it?

 

[dhookom]

Try

TRANSFORM Sum([CountOfSERVICE REQUESTED]) AS [SumOfCountOfSERVICE REQUESTED] 
SELECT [Technicians] 
FROM [Services Complete by Technician Part 2 Query]   
GROUP BY [Technicians] 
PIVOT Nz([SERVICE REQUESTED],"NA");

Duane
Hook'D on Access
MS Access MVP

 

[MichaelRed]

Alternatively, you might consider that the "<>" represents the quality (or the lack thereof) of the data, and review the data to understand the issue(s).

MichaelRed

 

[dhookom]

I think the issue is only because some techs haven't completed any type of Service. I suppose you could fire them ;-)

Duane
Hook'D on Access
MS Access MVP

 

[MichaelRed]

but isn't this "Valid" information? The names can be forced into the dataset!



MichaelRed