FireViking
Programmer
Hi all,
I must be one of these people that try and do things the hard way all the time.
This I hope will help others.
I created a table with 2 fields(Region and Invoices Issued) specifically for the data to be used in the chart.
Then used a query in the report_open() section to give me a sum of all Invoices issued for that region within a specific time frame.
I then used the rs.edit and rs.update to place the new data into the relavent feild of the table.
Finally bound the chart to the table and wulla, there you have it, a chart displaying the data I wanted.
If anyone wants any specifics let me know.
cheers.
I must be one of these people that try and do things the hard way all the time.
This I hope will help others.
I created a table with 2 fields(Region and Invoices Issued) specifically for the data to be used in the chart.
Then used a query in the report_open() section to give me a sum of all Invoices issued for that region within a specific time frame.
I then used the rs.edit and rs.update to place the new data into the relavent feild of the table.
Finally bound the chart to the table and wulla, there you have it, a chart displaying the data I wanted.
If anyone wants any specifics let me know.
cheers.