I hope you can understand this:
I am looking at making a form to show around 10 small charts. I would like to somehow have a query or something that would get all the unique sample names in a table and make that many charts (each sample name having its own chart). So lets say when someone opens the form and there is 7 unique sample names, the form shows 7 charts. This would be easy if I always had the same names, but there is the possiblity that some names maybe added sometime. Any one have any suggestions?
Thanks in advance,
Matthew
I am looking at making a form to show around 10 small charts. I would like to somehow have a query or something that would get all the unique sample names in a table and make that many charts (each sample name having its own chart). So lets say when someone opens the form and there is 7 unique sample names, the form shows 7 charts. This would be easy if I always had the same names, but there is the possiblity that some names maybe added sometime. Any one have any suggestions?
Thanks in advance,
Matthew