RE: Error message on Where statement

Try

SELECT [Enter Start Date] AS StartDate, [Enter End Date] AS EndDate,
[Monthly Reports]![Resolved by or last Assigned], Count(*) 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])


You are missing square brackets in [Resolved by or last Assigned] in the end
--
Good Luck
BS"D


"Frustrated in AL" wrote:

Same error message.

Am I wrong in assuming that the highlighted area of the SQL is the area that
is "having issues" after clicking on the OK of the error message? If not, it
has something to do with the "Where" statement because "Where" is highlighted.

"Ofer Cohen" wrote:

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
    ... Good Luck ... "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: Cannot add a DC, Access Denied
    ... error message and have been given many links. ... > I have done almost all like the following but no luck!!! ... > create a new account with admin rights etc and run DCpromo ... > dns is fine but no luck still ...
    (microsoft.public.win2000.active_directory)
  • RE: Security rollup for service pack
    ... I'm having the "blue screen" problem after installing this rollup. ... Has anyone had any luck fixing this? ... > After a recent windows update on Windows 2000 clients we are having numerous ...
    (microsoft.public.win2000.windows_update)
  • Re: Home network .pub file wont open...
    ... You receive a "File is not available" error message when you try to open an Office ... > I had a laptop which has a .pub file that I want to copy to my home network. ... I've closed all programs, but no luck. ... > I'm using publisher 2000 sp-3 on both machines, xp pro on the laptop and xp media ...
    (microsoft.public.publisher)
  • Where to Find Help Re Error Messages
    ... Can you help re error message or direct me to somewhere on ... I typed them into Google groups and had no luck. ... I use Windows XP, have Sygate firewall, NAV (scan every ... computer usage, unless it is the reason why I cannot go on ...
    (microsoft.public.windowsxp.general)
Quantcast