-----Original Message-----
Yes, that would be a problem in my opinion.
What are you trying to accomplish?
Can you use two queries and
PARAMETERS [What month?] IEEEDouble;
SELECT Sum([Enrollment]) as TotalEnroll
Sum(TotalApportAtt) as TotalApp
FROM ProbationMerced
WHERE ((([ProbationMerced].[Grade])<9) And
(([ProbationMerced].[Month])=[What month?])
Save that as QSumUp
PARAMETERS [What month?] IEEEDouble;
SELECT [ProbationMerced].[Grade],
[ProbationMerced].[Enrollment], [ProbationMerced]. [TotalApportAtt],
QSumUp.TotalEnroll ,
QSumUp.TotalApp
FROM ProbationMerced, QSumUp
WHERE ((([ProbationMerced].[Grade])<9) And
(([ProbationMerced].[Month])=[What month?]))
The problem with this is that you would be forced to enter the month twice and
the query results would not be updatable.
The other method would be to change your DSUM statement (s) to use criteria.
DSUM("Enrollment","ProbationMerced","Grade<9 AND [Month] =" & [What Month?])
Would it be the problem that this query is calling from
itself too? The query name is K-8Total_Query. In my
SELECT at the end, I have DSUM and it gets the Enrollment
sum from itself.
Thanks.
-----Original Message-----
It looks good to me. Although, I might TRY surrounding
K-
8Total_Query with brackets.
PARAMETERS [What month?] IEEEDouble;
SELECT [ProbationMerced].[Grade],
[ProbationMerced].[Enrollment],
[ProbationMerced].[TotalApportAtt],
DSum("[Enrollment]","[K-8Total_Query]") AS TotalK8Enroll,
DSum("[TotalApportAtt]","[K-8Total_Query]") AS TotalK8App
FROM ProbationMerced
WHERE [ProbationMerced].[Grade]<9 And
[ProbationMerced].[Month]=[What month?]
To trouble shoot try removing the criteria and the parameter and see if the
query works. If you still get the message, I would check the query's properties
to see if you have something strange in them
(especially
the sort and filter
properties).
If it is still broke after that, I would try making a new query that duplicates
this one.
Beyond that I am stuck.
acedia wrote:
PARAMETERS [What month?] IEEEDouble;
SELECT [ProbationMerced].[Grade], [ProbationMerced].
[Enrollment], [ProbationMerced].[TotalApportAtt], DSum
("[Enrollment]","K-8Total_Query") AS TotalK8Enroll, DSum
("[TotalApportAtt]","K-8Total_Query") AS TotalK8App
FROM ProbationMerced
WHERE ((([ProbationMerced].[Grade])<9) And
(([ProbationMerced].[Month])=[What month?]));
-----Original Message-----
Hard to say. Can you post your SQL statement?
Acedia wrote:
I'm creating a simple parameter query. When I run it,
it'll say "The expression you entered as a query
paramter
produced this error: .. can't find name 'What month?'
you
entered in the expression. I have: [What month?]
in
the
criteria and set in the Query parameter box. What am i
missing??? Thanks!
.
.
.
