Chart not updating correctly with query

[CaliburBlade138]

Hey all,



I have connected my chart via a query and it is not counting correctly. I have 2 different columns which either say 5555555/55 or Indirect Labor, now my query does a fine job of splitting that up but my chart seems to count the total records instead of the total of the keywords for a specific user. How can I fix this?

You can see here it is counting the total records instead of the total keywords...Attachment 47512

You can see here how the data is split into two columns so the query seems ok?Attachment 47513

These are the queries to split the data...

realORDERS: IIf(InStr([myBarcode],"Indirect")>0,"","Order")


realINDIRECT: IIf(InStr([myBarcode],"Indirect")>0,"Indirect","")

[June7]

You expect chart to show 4 Indirect and 3 Order?

Should probably use a CROSSTAB for the chart RowSource.

TRANSFORM Count(*) AS [Count]
SELECT Table1.myName
FROM Table1
GROUP BY Table1.myName
PIVOT IIf(InStr([myBarcode],"Indirect")>0,"Indirect","Order");

[CaliburBlade138]

Thank you, works.