Unique Work Order

[Jamie Dickerson]

I have a table that records reject rates for parts. Some of the fields
include Production Date, WO#, Operator 1, Reject Rate, etc.

For example Part#00001 may have 30 entries based on the date of production
and/or WO#.

I would like to summarize the reject rates for a part based on the WO# as
well as the Date. I have played around with the SQL to no avail (the fact
that I am a novice probably plays a huge part).

Could someone please help me.

 

[MGFoster]

I have a table that records reject rates for parts. Some of the fields
include Production Date, WO#, Operator 1, Reject Rate, etc.

For example Part#00001 may have 30 entries based on the date of production
and/or WO#.

I would like to summarize the reject rates for a part based on the WO# as
well as the Date. I have played around with the SQL to no avail (the fact
that I am a novice probably plays a huge part).

Could someone please help me.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You don't say how you want to "summarize" (SUM, COUNT, AVG ??)the data.
Probably something like this:

SELECT part_nbr, work_order, production_date,
AVG(reject_rate) As AvgRejectRate
FROM RejectionRates
GROUP BY part_nbr, work_order, production_date

This assumes that "reject_rate" is a number. Change the AVG to SUM or
COUNT if that is what you want.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSnm29IechKqOuFEgEQIj3ACfaLru3IlvqQqrfVgKs8zcuoXxeBEAmwTP
o94B0XwGjsBMtN5tist1yjrs
=vtkE
-----END PGP SIGNATURE-----