RE: Error message on Where statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From lookin at the SQL you dont have a space in this line

Count(*)([Monthly Reports]![Resolved by or last Assigned]) AS [Total Episodes
Resolved]

Try

SELECT [Enter Start Date] AS StartDate, [Enter End Date] AS EndDate,
Count(*) AS [Total Episodes Resolved]
WHERE [Monthly Reports].[Opened] Between [Enter Start Date] And [Enter
End Date]




--
Good Luck
BS"D


"Frustrated in AL" wrote:

I seem to be missing something here.

Error Message:
"The SELECT statement includes a reserved word or an argument name that is
misspelled or missing, or the punctuation is incorrect."

The SQL:
PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime;
SELECT [Enter Start Date] AS StartDate, [Enter End Date] AS EndDate,
Count(*)([Monthly Reports]![Resolved by or last Assigned]) AS [Total Episodes
Resolved]
WHERE ((([Monthly Reports].[Opened]) Between [Enter Start Date] And [Enter
End Date]))
GROUP BY ([Monthly Reports]!Resolved by or last Assigned);

When OK is clicked on the error message, the word WHERE is highlighted.

Name of TABLE: "Monthly Reports"
Date range shown in: "Opened" Field
GROUP BY is users, shown in: "Resolved by or last Assigned" Field.

Purpose of Query: Count the number of episodes, within a specific date
range and sort by user.

Any help would be appreciated.

.

Relevant Pages

  • Re: Error message on Where statement
    ... in the select are not using an aggregate function ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)
  • RE: Error message on Where statement
    ... You are missing square brackets in in the end ... Good Luck ... is "having issues" after clicking on the OK of the error message? ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)
  • Error message on Where statement
    ... I seem to be missing something here. ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)
  • RE: Error message on Where statement
    ... Okay, I've got the query running, but instead of giving me the user names ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)
  • RE: Error message on Where statement
    ... mybe the SQL should be ... Good Luck ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ...
    (microsoft.public.access.queries)