I need to do a report with graphs for the data below. Specifically, I
need to create a graph per store ID with all the quantities for that
store in a single graph. In other words, I need to group the data in a
single graph based on store id, with the date on the x-axis and qty on
y-axis. Any hints to do this? Thanks in advance.


Store_ID Purchase_Date Product Quantity
1-A 1-Nov-10 7
1-A 1-Nov-10 6
3-A 8-Nov-10 8
4-A 25-Oct-10 9
4-A 1-Nov-10 9
4-B 25-Oct-10 4
5-A 1-Nov-10 7
5-A 8-Nov-10 7
5-A 25-Oct-10 7
5-A 1-Nov-10 3

This may help:

http://tinyurl.com/2b7umjo
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access Solutions", published by Wiley


"Joe Smith" <bucbarrydb (AT) gmail (DOT) com> wrote