Creating Graphs in access on a click of a button

I need to create graphs in access in a lick of a button all the data will be in the sql transfered from the access.

If anybody did this before ar having Idea please let me know

It's not too difficult to do this because there is lots of Wizard help. First create a linked table to the SQL Server table from your Access database. Then use the Form Wizard or Report Wizard to create a chart using the linked table as the source of data.|||

hey taht was a really neat answer I havent tried it but as I am a begginer I may need help I will post further if I need any help

Thanks,

|||

may I know where can I find the report wizard in sql

|||I was talking about the Report Wizard in Microsoft Access. SQL Server does not have a report wizard. For SQL Server, you want to investigate installing SQL Server Reporting Services, it will let you create very nice reports inside Visual Studio against SQL Server.