Pie chart in Access 2007

[specsol]

I am new to this forum. Any help will be much appreciated. I cannot construct a pie chart on a form in Access 2007. I have a query which correctly groups the data with the correct numbers. The SQL is "SELECT tblCarers.EthnicOrigin, Count([tblCarers.ClientID]) AS CountOfEthnicOrigin
FROM tblCarers GROUP BY tblCarers.EthnicOrigin". I create a form via Form Design, enter the chart wizard and specify the query to generate the chart. After selecting the simple Pie Chart, the preview shows the graph correctly with the expected ethnic categories. Closing it down and completing the wizard preserts me with a pie chart where the categories are East, West, North. Showing the data label values generates unrelated numbers. Nothing I can do gives sense. Putting the same numbers into Excel generates a correct graph no problem. I must be doing something stupid but cannot see it. All help gratefully received

[specsol]

Some additional information that may give someone a clue. The Row Source for the faulty Pie Chart is

SELECT [EthnicOrigin],Sum([CountOfEthnicOrigin]) AS [SumOfCountOfEthnicOrigin] FROM [qryEthnicOrigin] GROUP BY [EthnicOrigin]

[specsol]

I have now solved the problem! the Row source above has "FROM [qryEthnicOrigin]" where it should be "FROM qryEthnicOrigin". Editing it manually makes it work.