Charts

[Finks]

Hi all,

I've been going round in circles for two days trying to solve this problem so any help would be much appreciated.
I have a table def query that produces a table giving monthly totals. I then use a chart on a form to display these totals. The chart works fine (after lots of trial and error) but the problem I have is that I now get several exact copies of the same chart. From what I can tell the form is displaying a chart for each record in the table although each chart is the same. Is there anyway to get the form to display just one chart per record that matches a given criteria?
If this makes no sense let me know and I’ll attach the Access database.

Thanks in advance

 

[IMO]

Try changing the Forms "Default View" properties from ContinuousForm to SingleForm

IMO

 

[Finks]

The form is currently set to single form as it can't be set to contiuous.

 

[IMO]

I think I'll need to see the db

IMO

 

[Finks]

I can't get the database small enough to attach and I've taken out absolutely everything that isn't relevant to this problem and most of the data.

 

[IMO]

Have you compacted it aswell?

IMO

 

[Finks]

Yep, zipped it up and it still comes in at 710KB

 

[IMO]

I've sent you a PM

IMO

 

[Rich]

The form that's displaying the chart should be UNBOUND, remove its data source

 

[Finks]

Thnx for the response, I just tried as you suggested and it works in that I now only have one chart but now instead of there being a chart displaying monthly totals for each machine I get one chart displaying the totals for all machines.
I'll try and explain more clearly -
I have a table that shows each machines totals per month. So if I have 2 machines with totals over 5 months (Jan to May for example) there would be 10 entries in the table (5 for one machine, 5 for the other). Before UNDOUNDing the form I would get a chart displaying the monthly totals for each machine but there would be 4 exact duplicates for each machine. After UNBOUNDing the form I get one chart but it shows the monthly totals of both machines combined.

 

[Rich]

Use a Totals query to group by Month and machine

 

[Finks]

Thankyou to you both for all your help.

I managed to resolve the problem by making the forms recordsource = to a table called Machines, this table holds a list of all the machines. Then set the forms filter to the required machines and it only displays graphs for those machines.

 

[IMO]

Glad you got it sorted

IMO