Report Chart Problem (1 Viewer)

[GaryPanic]

guys - hopefully a simple question ..

i have a chart - fine and dandy (pie chart)
and it works off a qry great-

but the qry has a mixture of currencies in it

data

contract (could be 6 or 7 )
amount

currency (could be 8 or 9)

chart works off the first two (but includes all currencies )but i want it to do a chart per currency (automatically )

i tried grouping - but no effect

any pointers would be appricated

 

[wiklendt]

would this help?

http://www.access-programmers.co.uk/forums/showpost.php?p=724327&postcount=25

 

[GaryPanic]

No - but thanks -I 'll have to do it a long winded way

I had hope to us sorting grouping

 

[Len Boorman]

How about a combo box with currencies that you select from as a paremeter of the chart query.

Alternatively if reports set of a bit of code to call each report say direct to printer

Len

 

[GaryPanic]

How about a combo box with currencies that you select from as a paremeter of the chart query.

Alternatively if reports set of a bit of code to call each report say direct to printer

Len

Len- your first option is the one that was the long winded route that i had in mind - (but thanks for the responce - it also shows that I was going down a route that wiser minds would have thought of.. )
ta
gbp