Error message on Where statement
- From: Frustrated in AL <FrustratedinAL@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 31 Mar 2008 10:34:48 -0700
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.
.
- Follow-Ups:
- Re: Error message on Where statement
- From: John Spencer
- RE: Error message on Where statement
- From: Ofer Cohen
- RE: Error message on Where statement
- From: Ofer Cohen
- Re: Error message on Where statement
- Prev by Date: Re: Is this possible in a Query
- Next by Date: MS Access Join Query
- Previous by thread: Adding ID field with numbers in increments of 100
- Next by thread: RE: Error message on Where statement
- Index(es):
Relevant Pages
|
