Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  SQL in ACCESS help

Author  Topic  robflint Starting Member 1 Post Posted - 2009-04-15 : 21:05:27 I have the following query as part of a VB script in access Const strcStub = "SELECT raw.Date, SUM(raw.ACDTime)/SUM(raw.ACDCalls)AS AVGTALK, (SUM(raw.ACWTime)/SUM(raw.ACDCalls))AS ACW, (SUM(raw.OtherTime)/SUM(raw.ACDCalls))AS HOLD, ((SUM(raw.ACDTIME)+SUM(raw.ACWTime)+SUM(raw.OtherTime))/SUM(raw.ACDCalls))AS AHT FROM raw GROUP BY raw.Date " The script runs fine if I remove the "raw.Date" and "GROUP BY raw.Date" statements... problemis I need themin the query this is supposed to be building Any help?