Date query--Urgent Help

[PANKAJINFO1]

I have a problem with the result of a Query.


Start Date
End Date


Query runs after entering unbound pameter text box Start and end date.
What i want is i am grouping of Opertaor, sum of defects between the dates.

but dates i am not able to group or sum or etc.

I want when the start and end date is entered

Operator Sum of Defects
A 25
B 75
C 12

SELECT tbloperator.[Operator Name] AS operator, tblModel.[Model Desc] AS Model, Sum([Daily Production].[Total Production]) AS Prod, Sum(tblinsp.[Number of Defects]) AS Defect, Round(([tblinsp].[Number of defects])/([daily production].[total production]*[tblmodel].[no of Joints])*1000000,2) AS PPM, tblModel.[No of Joints], Tblmain.date
FROM tbloperator INNER JOIN ((tblModel INNER JOIN [Daily Production] ON tblModel.Modelid = [Daily Production].[Model id]) INNER JOIN (tbldefect INNER JOIN (Tblmain INNER JOIN tblinsp ON Tblmain.inspid = tblinsp.inspid) ON tbldefect.defectid = tblinsp.defectid) ON tblModel.Modelid = tblinsp.modelid) ON tbloperator.operatorid = tblinsp.operatorid
WHERE (((Tblmain.date)=[daily production].[date]))
GROUP BY tbloperator.[Operator Name], tblModel.[Model Desc], Round(([tblinsp].[Number of defects])/([daily production].[total production]*[tblmodel].[no of Joints])*1000000,2), tblModel.[No of Joints], Tblmain.date, [Daily Production].[Model id]
HAVING (((Tblmain.date) Between [Forms]![Date Selection]![textdate] And [Forms]![Date Selection]![End date]))
ORDER BY tbloperator.[Operator Name];


Please help - Urgent

 

[DCrake]

Use a where condition in your query instead of putting the parameters underneath the actual fields. This removes the HAVING syntax.

David

 

[PANKAJINFO1]

I replaced group by with Where but still the same i am attaching the package i created.


use "date selection" Form PPMquery and run the query please check "Coil Shop" should be grouped but the problem is they are separated because dates are different.

What i want "Coil Shop" should in group.

Please select July ~Aug09 Dates.

 

[DCrake]

Without looking any deeper into your problem in your query you are using

Between x and Y and z you cannot do this

Also having fields called Date is only going to cause problems. This is a reserved word in Access. You need to change this ASAP.

David

 

[PANKAJINFO1]

please can you solve this.
i changed name of the field in inspdate

 

[PANKAJINFO1]

I changed that but still the same problem

 

[PANKAJINFO1]

Please check the problem.

Its really urgent.

 

[PANKAJINFO1]

Can Any Body Solve the problem in this forum.

Its Urgent

 

[PANKAJINFO1]

Can Any Body Solve the problem in this forum.

Its Urgent

 

[DCrake]

Bumping threads and crying out for help does not get you any more favour that waiting for members to give their FREE support. We do this out of kindness and it is not obligatory. It may be that someone is actually looking at this issue right now and are attempting to resolve it. If you cannot wait then I suggest you attempt to resolve it yourself.

David

 

[PANKAJINFO1]

Sorry For The texts But it was urgent

 

[PANKAJINFO1]

Can I Hope a Solution from The forum. I am still Hanging.

Please Solve