MS Access, Minitab, Control Charts & Six Sigma 6

[SmartCarFun]

Hello All,
This topic relates to getting access to deliver results formatted for Minitab. I want to use the power of MS Access to do my formatting for me.

Control Charts in Minitab work on sampling data everyday for a period, say a week or a month. Each day I take say 10 sample measurements and use these for testing.


My data consists of 3 columns

• Primary Key (ID)
• Date/time (Group)
• Result (Stg1)

The two key bits of information are date & value. I need to pick either the first 10, last 10, middle 10 or random 10 samples between any given date range. I then need to ignore the time value and group by the date value. The output should be similar to this sample in a subgroup size of 3 (to save space):


01/05/2012 / 0.689606482
01/05/2012 / 0.765625
01/05/2012 / 0.803796296

02/05/2012 / 0.0209375
02/05/2012 / 0.026087963
02/05/2012 / 0.031898148

03/05/2012 / 0.066493056
03/05/2012 / 0.067905093
03/05/2012 / 0.068773148

I began by trying this SQL query, this is as far as I got, any help appreciated. Small xls file attached with sample data...

SELECT [REMITS Query].ID, [REMITS Query].Group, [REMITS Query].Stg1
FROM [REMITS Query]
WHERE [REMITS Query].ID IN
   (SELECT TOP 10 ID
   FROM [REMITS Query] AS Dupe
   WHERE Dupe.Group = [REMITS Query].Group
   ORDER BY Dupe.Group DESC)
ORDER BY [REMITS Query].Group, [REMITS Query].Stg1;

PS there are a couple of parts to this question but this is a good starting point.