Chart in Grouped Report in Access 2007

[TD]

I have a grouped report in Access 2007, and I'm trying to create a chart that
changes with each group. I've done this before in Crystal Reports, but I
can't figure out how to do it in Access.

My report currently has one grouping based on a warehouse location. Each
record includes a cost field and a value field. I'd like to have a chart in
the group header that would sum the cost and value fields across the various
detail codes; the detail code is not the field used for the grouping.

Can anyone offer recommendations on how to accomplish this?

 

[Rob Parker]

Take a look at the "Sales By Category" report in the sample Northwind
database (comes with Access, but you may need to get it from the
distribution media if you didn't install it originally; it's probably also
available from the Microsoft Office site) has this feature.

HTH,

Rob

 

[DanH]

Which version of the Northwinds database. The 2007 doesn't have anything
called Sales by Category.

I did manage to screw the entire database up in about 2 minutes.