Chart shows total Count of records, instead of field value

[TinaS]

HI!

I've been working in Access for years -but - admittedly - there are some areas that I've never had need to work with - charting is one of them. Now I am doing what should be a simple chart - and I am sure it's an EASY fix - I just can't find it.

TRANSFORM Sum([OpenDays])*1 AS OpenDaysSum
SELECT qryChart.[TicketDate By Date]
FROM qryChart
GROUP BY qryChart.[TicketDate By Date]
PIVOT qryChart.ProviderCode;

This is the query that I have created - The first line I have to do to get it to work, though the ideal query would be:
TRANSFORM qryChart.OpenDays
SELECT qryChart.[TicketDate By Date]
FROM qryChart
GROUP BY qryChart.[TicketDate By Date]
PIVOT qryChart.ProviderCode;

As I want to pull the VALUE from the field [opendays] as the chart value.

In any event, when I am in the data source, previewing the query result in the chart properties, the data displays correctly.

When I view the chart, however, it does not give me the "VALUE" in field [opendays] but on the chart it isn't returning the field value. I'm not sure what I am doing wrong or even how to ask for help on it.

I'm trying to figure out WHAT total access is pulling - because it's definately NOT the field value - so it must be calculating or summing a field somewhere. Maybe you can ask some questions to help me give better info - I'm just not sure how to phrase it and am VERY Frustrated..

Thank you!

Tina

 

[dhookom]

1) are you showing us the SQL of the Row Source property of the Chart?
2) Do you have any values in the Link Master/Child properties of the chart?
3) If you don't want to use Sum(), you can use First(), Min(), or Max().

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[GingerR]

How about:

TRANSFORM First(qryChart.OpenDays) AS FirstOfOpenDays
SELECT qryChart.[TicketDate by Date]
FROM qryChart
GROUP BY qryChart.[TicketDate by Date]
PIVOT qryChart.ProviderCode;


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html