Thanks. That's definitely easier said than done. I will try to post sometime today. S2K5.

I have to re-think this.

1. In my SUM (CASE) the values are being multiplied i.e.,

disposition_ID(sum)*defect_ID

so, if disposition_ID (1) appears 72 times for defect_ID (19) then my results are 1368...

Lynn,

Here is the form.

FROM:

TO:

I would like to drill down my search but, I need to add more tables. The tables exist in SQL...

Thanks. That was the same thing I came up with:

INSERT INTO tbl_Assembly_Delay1(ID, Code, DelayTime)

SELECT ID , '#Trim(FORM.Code)#', '#Trim(FORM.DelayTime)#'

FROM tbl_Assembly_Production

WHERE tbl_Assembly_Production.WorkOrder = '#FORM.WorkOrder#'

I also ran into some other issues...

I made another change and I get this: Incorrect syntax near ','.

INSERT into tbl_Assembly_Delay(ID, Code, DelayTime)

SELECT ID

FROM tbl_Assembly_Production

WHERE tbl_Assembly_Production.WorkOrder = '#FORM.WorkOrder#' AND ('#Trim(FORM.Code)#' ,

'#Trim(FORM.DelayTime)#');

Thanks in advance:

I realized that logically I was incorrect. Below is where I attempted to correct my mistake. Now I get: "Incorrect syntax near 'Code'".

INSERT into tbl_Assembly_Delay(ID, Code, DelayTime)...

I think I found the solution.

Thanks.

SELECT

tlkp_Disposition.Disposition_Description, count(*) AS Disposition_Count, tlkp_Defects.Defect_Title

FROM

tbl_Assembly_Holds

join tlkp_Disposition on tbl_Assembly_Holds.Disposition_ID = tlkp_Disposition.Disposition_ID

...

Produce

Do Not Produce

Lowell,

I ran your code as is and it did not work. I made the corrections and it still did not work. I changed my code to this:

...

Lowell,

INSERT INTO tbl_Assembly_Production(dateProd, Shift, Area, Jig, EmpNo, WorkOrder, Item, ProdTime, CoTime, NpTime, UnitsProd, ProdDelayTime, CoDelayTime, Comment)

VALUES('#Trim(FORM.dateProd)#',

'#Trim(FORM.Shift)#',

...

You make a good point. The results I was looking for was 8/12 thru 8/13 that's why I set it to those parameters. However, users may want to include "today"...

Thanks X 1000.

I made a couple of changes to your solution and I got the results I am looking for.

SELECT

tlkp_Defects.Defect_Title,

count(*)

FROM

tbl_Assembly_Hold_Defects

...

SSCrazy,

That worked but what I am looking for is:

1. Count the defects by title through a date range.

2. Chart the range

3. Show how many occurred throughtout the range and not...

I just tried your script and this is my result:

"Error in list of function arguments: '.' not recognized.

Unable to parse query text."

Thanks for the reply. I asked because I want to create table from AD users and use in Coldfusion. To start over with ASP.Net would be a set...