Create charts using SQL statement?

[mrgreen]

Can this be done? I know I can create one using a Query but I am by no means an expert and was wondering how I can do this without the wizard?

Any help would be great!!!

Thanks

 

[ted.martin]

You could set the RecordSource proerty of the chart to an SQL statement and put that in the Load event