Hello Everybody,
I have a question about access charts as this is my first time working with them....I have a report that calculates clients wages and sums them up. the report works perfectly fine. I have thrown a column chart at the report footer which has a query that finds the sum of wages and groups them by the program the clients work for. when i run the report, the wages sum of the first program is correct, but the rest are wrong! heres the query:

SELECT Clients.Program, Sum(Clients.ODSP) AS ActualODSP
FROM Clients
GROUP BY Clients.Program
HAVING (((Clients.Program) Like "*" & [forms]![Main Form]![programTxt] & "*"));


Does anybody know wheres the issue is which am not catching?

Thanks in advance