Sadly i cant attach the table as it is at work, but ill try and describe better what i am doing. I ave a staff training database, it consists of a list of the staff and the date they have been trained. I want to create a graph which calculates the total number of poeple trained on each date. so for example if in the table there were 2 people trained on the 1/1/2007 i would want that shown on the graph. I have so far tried using a pivoert table which works but is not autoupdated and can not work with new data being added and taken away.

Hope this is a little clearer.

Cheers]

Chris