Pupilon
asked on
Scatter Graphs - Access with many records
Hi, everyone
I have a table in access with 120.000 records and I need to built a scatter graph with two of this columns, both of them are numeric. The graphs is correct but has a problem. It only takes the 3999 first records, the others are ignored.
Whay can i do?
Thanks in advance
Pupilon
I have a table in access with 120.000 records and I need to built a scatter graph with two of this columns, both of them are numeric. The graphs is correct but has a problem. It only takes the 3999 first records, the others are ignored.
Whay can i do?
Thanks in advance
Pupilon
what control are you sing to plot the scatter-grams?
ASKER
The table structure is :
Field1, Number, double.
Field2....
..
Field8, Number, double
Steps I'm doing.
1. Create a form
2. Insert Chart using de chart wizard
3. Select table, select field1, field8
4. Select XY(Scatter) Chart
5. In the Axis X I move field1 (In summarize I select, none)
6. In the Axis Y I move field8 (In summarize I select, none)
7. Finish
Now I'm in desing view of the form
Double click over the chart
Click on the icon "By column"
If I look at the Form-Datacheet it only has 3999 rows
I'll try to attach the access file
Thanks
Field1, Number, double.
Field2....
..
Field8, Number, double
Steps I'm doing.
1. Create a form
2. Insert Chart using de chart wizard
3. Select table, select field1, field8
4. Select XY(Scatter) Chart
5. In the Axis X I move field1 (In summarize I select, none)
6. In the Axis Y I move field8 (In summarize I select, none)
7. Finish
Now I'm in desing view of the form
Double click over the chart
Click on the icon "By column"
If I look at the Form-Datacheet it only has 3999 rows
I'll try to attach the access file
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's the first time I come here. I think your comment is very useful but I would like to know if your remarks about *FREE* mean if I got points in this web page I'w get another answer that can solve my problem?
Thanks a lot.
Pupilon
Thanks a lot.
Pupilon
no, I am talking about the price you paid for the CONTROL. not for the answer, that I have given you. After all, with 500 points and $4.50 US I can buy a Tall Mocha Latte at Starbucks Coffee House (exactly the same price with 0 points---Points are not worth anythin to me, so I give the same answer for 50 points as for 500 points).
what I meant by "To get more points, you may need to invest *significant* $$$ and purchase a specialty graphics package." was: to get more PLOTTED POINTS on your scatter-graph, not more EE points.
AW
what I meant by "To get more points, you may need to invest *significant* $$$ and purchase a specialty graphics package." was: to get more PLOTTED POINTS on your scatter-graph, not more EE points.
AW
AW