473,326 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Charting when using check boxes as data source

Morning,

The Non-conformance file we use as part of our Corporate GMP
Manufacturing complicance has a number of check boxes that users (7)
can select when determining what category a non-conformance falls
into. What I want to do is count and hence chart the values based on
the selected category type. BTW I cannot change the file and an
option group is not possible for the selections. I've managed to
create a crosstab that seems to be collating what I need, however I
really need to chart the types - Manangement think pretty charts work
better ;-) Anyeay, I've not been as yet been able to immedately find
what I need to do and was hoping for some guideance.

Regards,
Stinky Pete ;-)

Jul 31 '07 #1
1 1493
On Jul 31, 7:33 pm, Stinky Pete <Peter.Mor...@symbionhealth.com>
wrote:
Morning,

The Non-conformance file we use as part of our Corporate GMP
Manufacturing complicance has a number of check boxes that users (7)
can select when determining what category a non-conformance falls
into. What I want to do is count and hence chart the values based on
the selected category type. BTW I cannot change the file and an
option group is not possible for the selections. I've managed to
create a crosstab that seems to be collating what I need, however I
really need to chart the types - Manangement think pretty charts work
better ;-) Anyeay, I've not been as yet been able to immedately find
what I need to do and was hoping for some guideance.

Regards,
Stinky Pete ;-)
Use: 64 * [chk7] + 32 * [chk6] + 16 * [chk5] + 8 * [chk4] + 4 * [chk3]
+ 2 * [chk2] + [chk1] to choose the category from 128 possible values
in a table of categories. Some of the categories can be repeated for
multiple combinations. If the checkbox field values are -1 and 0, use
the Abs() function in conjuction with the calculation.

BTW, what are the names of your seven checkbox fields? I have to do
something very similar soon. Non-Conformance count (and frequency) is
one of the major metrics used in manufacturing processes to measure
quality improvement as per ISO recommendations.

James A. Fortune
CD********@FortuneJames.com

Aug 1 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jerry Sievers | last post by:
Dear Pythonists; I would appreciate a recommendation of a open source package for charting numeric data such as stock market quotes etc. Have such a thing in PHP called JPGraph which is very...
9
by: soni29 | last post by:
hi, i have written the following code, still in the learning stage: #include<iostream.h> class CBox { public: // Constructor definition CBox(double lv, double bv = 1.0, double hv = 1.0) :...
0
by: Matt. | last post by:
Hi all! I have a chart report based on a query (call it "query 2"). There are 4 fields in the query: X-Value, Y-Value, StartDate and EndDate. StartDate and EndDate are generated in "query 2"...
5
by: Jerry Hull | last post by:
I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new server installed and MS office upgraded from 2K (I...
8
by: Galina | last post by:
Hello I have 6 dependent list boxes on my ASP page:  Faculty;  Lecturer;  Course;  Course occurrence;  Group;  Week commencing date. When faculty is selected, lists of lecturers and...
10
by: A.M | last post by:
Hi, I developed a HTML reporting tool that renders Oracle data to HTML and Oracle. At this point I have to add charts (3d bars and pie charts) to this
3
by: Igor | last post by:
Hi all, I'm looking for a tool that can design charts and save chart definitions in a file. I would put those chart definitions in a database and then later load them and render charts (as...
1
by: DJG79 | last post by:
Hi all, I am using an open source menu that i found and it works great, except for one thing that when the web page is not scrolled to the very top the drop down links will not stay visible. Has...
20
by: Joe | last post by:
Is any one charting packing considered to be the "best"? We've used ChartFX but wasn't too happy about the way data had to be populated along with some other issues which slip my mind right now and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.